I am a DBA on DB2 Z/os V8 NFM. I am seeing the error listed below in the DB2 master. This type of error has been seen previously. in an attempt to reduce / eliminate the error the decision was made to increase the PCTFREE and add FREEPAGE to the tablespace. The partitions have been altered for these settings. The table is inserted to in high order sequence based on an identity key field. Based on that information the highest 20 parts used were reorged this past weekend. Updates may occur in prior parts. What I am trying to determine is the partition associated to the page number given in the error message. This will help me to determine if the page is in one of the parts reorged and upgraded, one of the older parts not yet upgraded, or finally if it has rolled to the next empty part, that has not yet been upgraded (currrently my assumption). I really appreciate any information that would help in this determination.
06.07.31 STC51645 DSNT375I -DBP3 PLAN=DISTSERV WITH 916
916 CORRELATION-ID=DataFlowEngi
916 CONNECTION-ID=SERVER
916 LUW-ID=GA21502C.OAAC.081104110658=55121
916 THREAD-INFO=GSB3APP#:wdc4119a:gsb3app#:DataFlowEngine
916 IS DEADLOCKED WITH PLAN=DISTSERV WITH
916 CORRELATION-ID=DataFlowEngi
916 CONNECTION-ID=SERVER
916 LUW-ID=GA21502B.O8B2.081104095004=37344
916 THREAD-INFO=GSB3APP#:wdc5132a:gsb3app#:DataFlowEngine
916 ON MEMBER DBP1
06.07.31 STC51645 DSNT501I -DBP3 DSNILMCL RESOURCE UNAVAILABLE 917
917 CORRELATION-ID=DataFlowEngi
917 CONNECTION-ID=SERVER
917 LUW-ID=GA21502C.OAAC.081104110658=365505
917 REASON 00C90088
917 TYPE 00000302
917 NAME GB3A3001.PSCLTX .X'2A03EEE7'
Digger61