DB2 USERSPACE1 is full

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 = 2 Name = USERSPACE1 Type = Database managed space Contents = All permanent data. Large table space. State = 0x0000 Detailed explanation: Normal Total pages = 81920 Useable pages = 81888 Used pages = 80288 Free pages = 1600 High water mark (pages) = 80288 Page size (bytes) = 4096 Extent size... Read more →

DB2 V95 uninstall itma

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. Uninstall of ITMA shipped with DB2 can be completed by: $DB2DIR/itma/bin/uninstall REMOVE EVERYTHING Ref:Jack Vamvas(http://dba-db2.com) Read more →

DB2Autostart and DB2 fault monitor controller command

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 ------------------------ ------------- ----- DB2AUTOSTART YES I DB2ADMINSERVER dasusr1 G DB2COMM tcpip I DB2SYSTEM ukrhdb2p02.t G DB2_EEE_LICENSE_POLICY 281479271743 G with various values . Estimate from these value your next course of action. You can also use, although beginning with DB2 V8 - this is no longer supported. db2set DB2AUTOSTART -i If DB2AUTOSTART = "YES" than db2autostart is OK , If it is set at NO , issue... Read more →