Local fix information for APAR IC81015

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.