Troubleshooting
Problem
This document provides local fix instructions for APAR IC81015.
Symptom
If you are experiencing the issues described in APAR IC81015 and cannot wait for the appropriate fixing level of the Tivoli Storage Manager server, follow these instructions.
Resolving The Problem
The instructions prevent unconditional reorganization from running on the larger tables of the server. After running these commands, reorganization occurs only as indicated by DB2 on those larger tables.
In the following commands, the <timestamp> is today's date, in the format yyyy-mm-dd-06.00.00. Note that the hour, minutes, and seconds fields must be syntactically correct, and 6 a.m. is used as the time. So, if today's date were January 30, 2012, the <timestamp> would be '2012-01-30-06.00.00'.
Issue the following commands:
db2 connect to tsmdb1
db2 set schema tsmdb1
db2 "delete from global_attributes where owner='RDB' and
name='REORG_TB_BACKUP_OBJECTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_TB_BACKUP_OBJECTS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB' and
name ='REORG_IX_BACKUP_OBJECTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_IX_BACKUP_OBJECTS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB'
and name ='REORG_TB_ARCHIVE_OBJECTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_TB_ARCHIVE_OBJECTS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB' and
name ='REORG_IX_ARCHIVE_OBJECTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_IX_ARCHIVE_OBJECTS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB'
and name ='REORG_TB_BF_AGGREGATED_BITFILES' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_TB_BF_AGGREGATED_BITFILES',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB' and
name ='REORG_IX_BF_AGGREGATED_BITFILES' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_IX_BF_AGGREGATED_BITFILES',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB'
and name ='REORG_TB_BF_BITFILE_EXTENTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_TB_BF_BITFILE_EXTENTS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB' and
name ='REORG_IX_BF_BITFILE_EXTENTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_IX_BF_BITFILE_EXTENTS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB'
and name ='REORG_TB_BF_QUEUED_CHUNKS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_TB_BF_QUEUED_CHUNKS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB' and
name ='REORG_IX_BF_QUEUED_CHUNKS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_IX_BF_QUEUED_CHUNKS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB'
and name ='REORG_TB_BF_DEREFERENCED_CHUNKS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_TB_BF_DEREFERENCED_CHUNKS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB' and
name ='REORG_IX_BF_DEREFERENCED_CHUNKS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_IX_BF_DEREFERENCED_CHUNKS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB'
and name ='REORG_TB_AF_SEGMENTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_TB_AF_SEGMENTS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB' and
name ='REORG_IX_AF_SEGMENTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_IX_AF_SEGMENTS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB'
and name ='REORG_TB_AS_SEGMENTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_TB_AS_SEGMENTS',5,6,'<timestamp>' ) "
db2 "delete from global_attributes where owner='RDB' and
name ='REORG_IX_AS_SEGMENTS' "
db2 "insert into global_attributes
(owner,name,type,length,datetime)
values('RDB','REORG_IX_AS_SEGMENTS',5,6,'<timestamp>' ) "
When running these commands, you might see errors from the "delete from global_attributes" command. Here is an example:
SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a
query is an empty table. SQLSTATE=02000
These errors from the "delete from global_attributes" command can be ignored.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21580621