DSN1COMP getting message DSN1941I

Steven Lamb

DSN1COMP getting message DSN1941I
Dear Listers,

Hopefully somebody will be able to spot my deliberate mistake ...
DB2 OS/390 v7
I am trying to run DSN1COMP against a full image copy of a partittioned
tablespace using the following parms

//S010 EXEC PGM=DSN1COMP,
// PARM=('FULLCOPY,NUMPARTS(12),ROWLIMIT(200000)',
// 'PAGESIZE(4K),PCTFREE(0),FREEPAGE(0)')

However, I get the following when I run the job

DSN1999I START OF DSN1COMP FOR JOB TXXDB204 S010
DSN1998I INPUT DSNAME = DB2PIC.TMS.ICOPY.DVEAEP03.STRD.G4706V00 , SEQ
DSN1944I DSN1COMP INPUT PARAMETERS
4,096 DICTIONARY SIZE USED
0 FREEPAGE VALUE USED
0 PCTFREE VALUE USED
200,000 ROWLIMIT REQUESTED
12 NUMBER OF PARTITIONS
ESTIMATE BASED ON DB2 LOAD METHOD
255 MAXROWS VALUE USED

DSN1941I DSN1COMP COMPRESSION ESTIMATE WAS NOT CALCULATED
DSN1941I DSN1COMP COMPRESSION ESTIMATE WAS NOT CALCULATED
DSN1993I DSN1COMP TERMINATED, 3 PAGES PROCESSED

I don't understand why it's only reading 3 pages - the actual tablespace
has 288,000 active pages. I've tried specifying REORG in the input and
varying ROWLIMIT and still get the same results. The tablespace is not
compressed already although the 3 parts are currently empty.
Any thoughts?

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