DB2 OS/390 v7 S0C4 on REORG using LIST - confused

Steven Lamb

DB2 OS/390 v7 S0C4 on REORG using LIST - confused
After inserting a row and deleting it again from the empty part 4, Reorg
now works ...

Yours in confusion,

Steve

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Roy Cornford

Re: DB2 OS/390 v7 S0C4 on REORG using LIST
(in response to Steven Lamb)
Steve,

Was the the object defined as DEFINE NO?

I think you should take this up with IBM service, if you haven't already
done so....

Roy

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Michael Ebert

Re: DB2 OS/390 v7 S0C4 on REORG using LIST
(in response to Roy Cornford)
It cannot have been DEFINE NO, because the other partitions contained data
(all partitions of a TS must be defined or undefined together).

I seem to dimly recall a PTF that fixed some problems with compression
dictionaries, but it must have been a long time ago. Did you check on
IBMLINK for APARs with the info you got from the SDSF LOG (dump title etc)?

Dr. Michael Ebert
DB2 Database Administrator
aMaDEUS Data Processing
Erding / Munich, Germany




From: Roy Cornford <[login to unmask email]>@IDUGDB2-L.ORG on 10-01-2005
09:31 CST

Please respond to DB2 Database Discussion list at IDUG
<[login to unmask email]>

Sent by: DB2 Data Base Discussion List <[login to unmask email]>



To: [login to unmask email]


cc:






Subjec Re: [DB2-L] DB2 OS/390 v7 S0C4 on
t: REORG using LIST








Steve,

Was the the object defined as DEFINE NO?

I think you should take this up with IBM service, if you haven't already
done so....

Roy

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steven Lamb

Re: DB2 OS/390 v7 S0C4 on REORG using LIST
(in response to Michael Ebert)
I had a look on the IBM APAR database and couldn't find anything that
seemed to fit the symptoms. The fact that if I insert and then delete a
row, the partition is OK is also a little strange. This is on a test
system, so I can't really say if anything funny has happened to the
underlying VSAM datasets - like being archived and then restored. We're
applying some maintenance shortly - I'll see if it still happens after that.

Thanks for the help,

Steve

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mark Vickers

Re: DB2 OS/390 v7 S0C4 on REORG using LIST
(in response to Steven Lamb)
Steve,
We do not use compression, so I don't know much about it, but the fact that
you got the message:
COMPRESSION DICTIONARY DOES NOT EXIST FOR TABLE SPACE E1CSED1.SCSTCPS
It looks like this is not built until and insert is applied to that
partition.
That still sounds wrong, but maybe that symptom may lead to a result on
IBMLINK ?!?
ciao,
Mark.

-----Original Message-----
From: Steve Lamb [mailto:[login to unmask email]
Sent: Tuesday, January 11, 2005 4:50 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 OS/390 v7 S0C4 on REORG using LIST

I had a look on the IBM APAR database and couldn't find anything that
seemed to fit the symptoms. The fact that if I insert and then delete a
row, the partition is OK is also a little strange. This is on a test
system, so I can't really say if anything funny has happened to the
underlying VSAM datasets - like being archived and then restored. We're
applying some maintenance shortly - I'll see if it still happens after that.

Thanks for the help,

Steve

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Mark McCormack

DB2 OS/390 v7 S0C4 on REORG using LIST
(in response to Mark Vickers)
Steve,


COMPRESSION DICTIONARY DOES NOT EXIST FOR TABLE SPACE E1CSED1.SCSTCPS,
PARTITION 4



Your symptoms seem a bit similar to a problem we had last year with the
load utility. We had some table partitions where there were pages with
compressed rows but the dictionary pages had disappeared. I can't remember
what we did to get into that mess. There was an apar / ptf. Perhaps they
will help. PQ79961 / UQ82063

Mark

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steven Lamb

Re: DB2 OS/390 v7 S0C4 on REORG using LIST
(in response to Mark McCormack)
Mark,

Thanks for that - the replacement PTF UQ85778 is working its way through
our subsystems at the moment, so I'll see what happens in a couple of weeks!

Regards,

Steve

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steven Lamb

Re: DB2 OS/390 v7 S0C4 on REORG using LIST
(in response to Steven Lamb)
Success!

I've just tried the job again on a subsystem where the latest (for us)
maintenance has been applied and the Reorg works on an empty partition.
I was able to recreate the problem on the original subsystem by doing a
Load Replace amd only putting data into some partitions - the Reorg abended
with an S0C4 on an empty partition.
Did the same on the subsystem with the maintenance on and it worked without
any problems. The messages produced during the Reorg are also different:

Failing subsystem:
DSNU243I ) DSNURFIT - COMPRESSION DICTIONARY DOES NOT EXIST FOR TABLE
SPACE E1CSED1.SCSTCPS, PARTITION 4
DSNU245I ) DSNURBDC - THE COMPRESSION DICTIONARY WAS NOT BUILT FOR TABLE
SPACE E1CSED1.SCSTCPS, PARTITION 4
DSNU251I DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLESPACE E1CSED1.SCSTCPS PART 4
DSNU250I DSNUGSRT - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
DSNU395I DSNURPIB - INDEXES WILL BE BUILT IN PARALLEL, NUMBER OF TASKS =
4
DSNU017I DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED,
REASON=X'00C4'


Subsystem with maintenance:
DSNU243I ( DSNURFIT - COMPRESSION DICTIONARY DOES NOT EXIST FOR TABLE
SPACE D1CSUT1.SCSTCPS, PARTITION 4
DSNU245I ( DSNURBDC - THE COMPRESSION DICTIONARY WAS NOT BUILT FOR TABLE
SPACE D1CSUT1.SCSTCPS, PARTITION 4
DSNU251I DSNUGSRT - UNLOAD PHASE STATISTICS - NUMBER OF RECORDS
UNLOADED=0 FOR TABLESPACE D1CSUT1.SCSTCPS, PARTITION 4
DSNU250I DSNUGSRT - UNLOAD PHASE COMPLETE, ELAPSED TIME=00:00:00
DSNU303I ( DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=0 FOR
TABLE SPACE D1CSUT1.SCSTCPS, PARTITION 4
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS
PROCESSED=0
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED TIME=00:00:02
DSNU380I ( DSNUGSRX - TABLESPACE D1CSUT1.SCSTCPS PARTITION 4 IS IN COPY
PENDING
DSNU570I ( DSNUGSRX - INDEX D1CSUT1.XCSTCPS1 PARTITION 4 IS IN
INFORMATIONAL COPY PENDING
DSNU010I DSNUGBAC - UTILITY EXECUTION COMPLETE, HIGHEST RETURN CODE=4

Chalk up another success for the List!

Regards,

Steve

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm