|
|
-
|
|
Managing statistics is important for index performance. A quick way of displaying the last time statistics were updated is with this sql statement.
Select
tabschema
,tabname
,stats_time
from syscat.tables
where type = 'T'
Republished from http://www.dba-db2.com/.......
|
|
-
|
|
One of our system administrators – who manages the Integrated Tivoli Monitoring Applications (ITMA) - noticed that the ITM package that ships with DB2 V95 was installed.
As he manages separate installs of ITM – the request was to uninstall the ITM from the particular Linux Server.
Un......
|
|
-
|
|
The reason this error is occurring is that the objects loaded into the transaction which is causing the the transaction logs to overfill.
By default the amount of secondary log files is 2.
Resolve the problem by increasing the amount of secondary log files:
db2 update db cfg for MY_DB_NAME using ......
|
|
-
|
|
Step 1 - connect to the db, and run the following command.
select
substr(reg_var_name,1,24) as reg_var_name,
substr(reg_var_value,1,12) as reg_var_value,
level
from table(sysproc.reg_list_variables()) as registryinfo
this will return:
REG_VAR_NAME REG_VAR_VALUE LEVEL
-----......
|
|
-
|
|
Users started reporting some inconsistency on connecting to a database on DB2 9.5 on RHEL 5.I performed an initial check on connecting via Putty, and received an error of not being able to access the table container.
A db2dialog.log snippet revealed:
ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_A......
|
|
-
|
|
If on the command line use, LIST APPLICATIONS.
If you were using a client such as Putty – logon as relevant user, The logon account must have at least one of these Authorisations: sysadm, sysctrl, sysmaint, sysmon.
--STEP 1 – connect to relevant database
$db2 connect to
--STEP 2
$......
|
|
-
|
|
After a period of usage – quite often I see these type of messages on the monitoring reports.
USERSPACE1 in MYDB has 98 pct used. Instance: MyInstance
The first step I take is:
Db2 connect to MYDB
db2 list tablespace containers for 2 show detail.
Tablespace ID ......
|
|
-
|
|
I started seeing this message appear in the backup logs:
SQL2413N Online backup is not allowed because the database is not recoverable
or a backup pending condition is in effect.
The problem was Archival Logging wasn’t enabled on the databases. The problem was rectified by:
db2 update db ......
|
|
-
|
|
If you are using DB2 9.5 and need to track the memory usage of an instance, then db2pd -db2ptnmem displays the output of current memory and the highwater mark of the memory segments.
It is worth mentioning that with DB2 9.5 the INSTANCE_MEMORY becomes the memory allocation delimiter. If set at AUTO......
|
|
-
|
|
show tables;
+-------------------+
| Tables_in_MYDB |
+-------------------+
| archive |
| ......
|
|