Antwort: [DB2-L] DSN1COMP getting message DSN1941I

Roy Boxwell

Antwort: [DB2-L] DSN1COMP getting message DSN1941I
Hi Steve!

Very simple, the message is written out when there is no data to build a
compression dictionary. You *must* have data to build a compression
dictionary!
The 3 pages that were read were quite possibly header pages that then
informed DSN1COMP that there was no actual data to work with.

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-35
E-mail [login to unmask email]
Homepage www.seg.de





Steve Lamb <[login to unmask email]>
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
11.01.2006 11:18
Bitte antworten an DB2 Database Discussion list at IDUG


An: [login to unmask email]
Kopie:
Thema: [DB2-L] 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



---------------------------------------------------------------------------------
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: Antwort: [DB2-L] DSN1COMP getting message DSN1941I
(in response to Roy Boxwell)
Roy,

I'm afraid I'm still confused! There is data in the table - over 3m rows,
but starting in part 4. I tried specifying a huge ROWLIMIT (2m) but it
still made no difference. It's as though the utility gets bored after only
3 pages.

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

John Lendman

Re: DSN1COMP getting message DSN1941I
(in response to Mike Holmans)
Make sure that your Image copy you are using is good.

John C. Lendman
IBM Certified Solutions Expert
IBM Certified Database Administrator
DB2 Universal Database V8.1 for zOS
Office 561-357-7523
Cell 772-485-1592
Email [login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Steve Lamb
Sent: Wednesday, January 11, 2006 5:19 AM
To: [login to unmask email]
Subject: [DB2-L] 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

---------------------------------------------------------------------------------
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

Mike Holmans

Re: DSN1COMP getting message DSN1941I
(in response to Steven Lamb)
Steve,

ROWLIMIT isn't a count: DSN1COMP works out how much space ROWLIMIT *
row_length equates to and reads that much of the input dataset, so if
you specify 200000 for a table with a row length of 200, DSN1COMP will
read the first 40Mb of the input and then stop. So, in your situation,
it's reading 40Mb of an empty partition.

I notice that you're using an image copy of a partitioned ts. You might
want to note the following from the manual:

"DSN1COMP terminates and issues message DSN1946I when it encounters an
image copy that contains multiple partitions; a
compression report is issued for the first partition."

Mike Holmans
BT Exact OneIT Operational Integrity
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Steve Lamb
Sent: 11 January 2006 10:19
To: [login to unmask email]
Subject: [DB2-L] 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

---------------------------------------------------------------------------------
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: DSN1COMP getting message DSN1941I
(in response to John Lendman)
Mike,

Thanks for that - I missed the bit about partitioned tablespace IC's in the
manual; I looked through it again after reading your reply and STILL missed
it!It looks like the fact that the first 3 parts are empty is what's
stuffing me - and there's no "skip" keyword either like in REPRO!

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: DSN1COMP getting message DSN1941I
(in response to Steven Lamb)
Cunning plan B! I've taken a copy of partition 4 (containing data) and
used that as input to DSN1COMP. That worked - 59% reduction would be
possible!

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