DSN1COMP-Utility and the SIZE-parameter

Georg Peter

DSN1COMP-Utility and the SIZE-parameter
First a happy and successful New Year 2001 to all of you out there.

Second a question:
When we're using the DSN1COMP-Utility we declare

//SYSIN DD *
DSN1COMP SIZE(1024) ROWLIMIT(20000)

That works very well with "normal" tablespaces because most of our
tablespaces are residing in 4K-bufferpools.

If we ran the utility against a tablespace that is residing in a
32K-bufferpool we received a CC8 and the messages:
IGD104 I - DSNDBCAT.DSNDBC.LEWDBDIG.LEWTSDIG.I0001.A001 RETAINED
DDNAME=SYSUT1
and a lot of
DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00000000. "
DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00000001. "
DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00404040. " REASON: NOT-FILE BIT
ON.
SERVIVE INFO: CODE= 'C03X' PGFLAGS='40'X
and so on.

Could it be that the SIZE parameter must have another value than the shown
1024 ?

But what is the right value in this case ? 32768 ?

Thanks for any help.

With kind regards - mit freundlichen Grüssen,
G e o r g H . P e t e r
DB2 Data Base Administrator c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Software Development & Technology Center
Knowlegde Center Database Systems
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------

"Keep it simple if you can, but go complex whenever you can't go simple!"



Linda Billings

Re: DSN1COMP-Utility and the SIZE-parameter
(in response to Georg Peter)
Hello, Georg,
I cannot find the SIZE parameter in the utility manual but I have
used PAGESIZE(32K) to indicate that I am using a tablespace with 32K pages.
The default page size is 4K. Perhaps this will help.

Linda Billings
Enterprise Systems Programmer
Info-Tech Services
Department of Administration
State of Wisconsin

"The basis of optimism is sheer terror." - Oscar Wilde


-----Original Message-----
From: Peter, Georg [mailto:[login to unmask email]
Sent: Wednesday, January 03, 2001 8:52 AM
To: [login to unmask email]
Subject: DSN1COMP-Utility and the SIZE-parameter


First a happy and successful New Year 2001 to all of you out there.

Second a question:
When we're using the DSN1COMP-Utility we declare

//SYSIN DD *
DSN1COMP SIZE(1024) ROWLIMIT(20000)

That works very well with "normal" tablespaces because most of our
tablespaces are residing in 4K-bufferpools.

If we ran the utility against a tablespace that is residing in a
32K-bufferpool we received a CC8 and the messages:
IGD104 I - DSNDBCAT.DSNDBC.LEWDBDIG.LEWTSDIG.I0001.A001 RETAINED
DDNAME=SYSUT1
and a lot of
DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00000000. "
DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00000001. "
DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00404040. " REASON: NOT-FILE BIT
ON.
SERVIVE INFO: CODE= 'C03X' PGFLAGS='40'X
and so on.

Could it be that the SIZE parameter must have another value than the shown
1024 ?

But what is the right value in this case ? 32768 ?

Thanks for any help.

With kind regards - mit freundlichen Grüssen,
G e o r g H . P e t e r
DB2 Data Base Administrator c/o
-------------------------------------------------------------------
Datenzentrale Baden-Wuerttemberg
Software Development & Technology Center
Knowlegde Center Database Systems
Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
e:mail [login to unmask email]
Phone 0049-711-8108-271
PC-Fax 004971189696071
Internet (only in german language):http://www.dzbw.de
----------------------------------------------------------------------

"Keep it simple if you can, but go complex whenever you can't go simple!"



http://www.ryci.com/db2-l. The owners of the list can be reached at
[login to unmask email]



Max Scarpa

Re: DSN1COMP-Utility and the SIZE-parameter
(in response to Linda Billings)
Hi all.....

There's a parameter 32K to declare if SYSUT1 dataset is 32K size in
DSN1COMP, as in DSN1COPY.

HTH

Max Scarpa
Db2 sysprog

Of course all disclaimer from here to 3C-273 apply.



Sanjeev (CTS) S

Re: DSN1COMP-Utility and the SIZE-parameter
(in response to Max Scarpa)
Hi,
I think replies from Max and Linda explained both the options
for specifying the pagesize. It can either be given by option 32K (for 32K
pages only) or by option PAGESIZE(32K)
something like this i think : DSN1COMP 32K
ROWLIMIT(20000) or

DSN1COMP PAGESIZE(32K) ROWLIMIT(20000)

Another point which i think the Util guide says that
preferred option is using PAGESIZE, not sure why !!.One more interesting
thing i found in the util guide which i think most of you have gone through
:
If you omit PAGESIZE,DSN1COMP tries to determine the page
size from the input data set.DB2 issues an error message if
DSN1COMP cannot determine the input page size.This might
happen if the header page is not in the input data set,or the page size
field in the header page contains an invalid page size(HOW ????) .

Regards,
Sanjeev


> -----Original Message-----
> From: Billings, Linda [SMTP:[login to unmask email]
> Sent: Wednesday, January 03, 2001 8:30 PM
> To: [login to unmask email]
> Subject: Re: DSN1COMP-Utility and the SIZE-parameter
>
> Hello, Georg,
> I cannot find the SIZE parameter in the utility manual but I have
> used PAGESIZE(32K) to indicate that I am using a tablespace with 32K
> pages.
> The default page size is 4K. Perhaps this will help.
>
> Linda Billings
> Enterprise Systems Programmer
> Info-Tech Services
> Department of Administration
> State of Wisconsin
>
> "The basis of optimism is sheer terror." - Oscar Wilde
>
>
> -----Original Message-----
> From: Peter, Georg [mailto:[login to unmask email]
> Sent: Wednesday, January 03, 2001 8:52 AM
> To: [login to unmask email]
> Subject: DSN1COMP-Utility and the SIZE-parameter
>
>
> First a happy and successful New Year 2001 to all of you out there.
>
> Second a question:
> When we're using the DSN1COMP-Utility we declare
>
> //SYSIN DD *
> DSN1COMP SIZE(1024) ROWLIMIT(20000)
>
> That works very well with "normal" tablespaces because most of our
> tablespaces are residing in 4K-bufferpools.
>
> If we ran the utility against a tablespace that is residing in a
> 32K-bufferpool we received a CC8 and the messages:
> IGD104 I - DSNDBCAT.DSNDBC.LEWDBDIG.LEWTSDIG.I0001.A001 RETAINED
> DDNAME=SYSUT1
> and a lot of
> DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00000000. "
> DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00000001. "
> DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00404040. " REASON: NOT-FILE
> BIT
> ON.
> SERVIVE INFO: CODE= 'C03X' PGFLAGS='40'X
> and so on.
>
> Could it be that the SIZE parameter must have another value than the shown
> 1024 ?
>
> But what is the right value in this case ? 32768 ?
>
> Thanks for any help.
>
> With kind regards - mit freundlichen Grüssen,
> G e o r g H . P e t e r
> DB2 Data Base Administrator c/o
> -------------------------------------------------------------------
> Datenzentrale Baden-Wuerttemberg
> Software Development & Technology Center
> Knowlegde Center Database Systems
> Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
> e:mail [login to unmask email]
> Phone 0049-711-8108-271
> PC-Fax 004971189696071
> Internet (only in german language):http://www.dzbw.de
> ----------------------------------------------------------------------
>
> "Keep it simple if you can, but go complex whenever you can't go simple!"
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]
-----------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------



Georg Peter

AW: DSN1COMP-Utility and the SIZE-parameter
(in response to Sanjeev (CTS) S)
Linda & Max & Sanjeev,

thanks for your advice.. With using //COMPEVAL EXEC
PGM=DSN1COMP,PARM='32K,REORG,ROWLIMIT(50000)' the utility works.

With kind regards - mit freundlichen Grüssen,
G e o r g
----------------------------------------------------------------------

"Long ago, when knights were bold, dragons walked the earth, and
both DB2 and I were young, I had a real job. I was a programmer."

-----Ursprüngliche Nachricht-----
Von: S, Sanjeev (CTS) [mailto:[login to unmask email]
Gesendet am: Donnerstag, 4. Januar 2001 08:26
An: [login to unmask email]
Betreff: Re: DSN1COMP-Utility and the SIZE-parameter

Hi,
I think replies from Max and Linda explained both the options
for specifying the pagesize. It can either be given by option 32K (for 32K
pages only) or by option PAGESIZE(32K)
something like this i think : DSN1COMP 32K
ROWLIMIT(20000) or

DSN1COMP PAGESIZE(32K) ROWLIMIT(20000)

Another point which i think the Util guide says that
preferred option is using PAGESIZE, not sure why !!.One more interesting
thing i found in the util guide which i think most of you have gone through
:
If you omit PAGESIZE,DSN1COMP tries to determine the page
size from the input data set.DB2 issues an error message if
DSN1COMP cannot determine the input page size.This might
happen if the header page is not in the input data set,or the page size
field in the header page contains an invalid page size(HOW ????) .

Regards,
Sanjeev


> -----Original Message-----
> From: Billings, Linda [SMTP:[login to unmask email]
> Sent: Wednesday, January 03, 2001 8:30 PM
> To: [login to unmask email]
> Subject: Re: DSN1COMP-Utility and the SIZE-parameter
>
> Hello, Georg,
> I cannot find the SIZE parameter in the utility manual but I have
> used PAGESIZE(32K) to indicate that I am using a tablespace with 32K
> pages.
> The default page size is 4K. Perhaps this will help.
>
> Linda Billings
> Enterprise Systems Programmer
> Info-Tech Services
> Department of Administration
> State of Wisconsin
>
> "The basis of optimism is sheer terror." - Oscar Wilde
>
>
> -----Original Message-----
> From: Peter, Georg [mailto:[login to unmask email]
> Sent: Wednesday, January 03, 2001 8:52 AM
> To: [login to unmask email]
> Subject: DSN1COMP-Utility and the SIZE-parameter
>
>
> First a happy and successful New Year 2001 to all of you out there.
>
> Second a question:
> When we're using the DSN1COMP-Utility we declare
>
> //SYSIN DD *
> DSN1COMP SIZE(1024) ROWLIMIT(20000)
>
> That works very well with "normal" tablespaces because most of our
> tablespaces are residing in 4K-bufferpools.
>
> If we ran the utility against a tablespace that is residing in a
> 32K-bufferpool we received a CC8 and the messages:
> IGD104 I - DSNDBCAT.DSNDBC.LEWDBDIG.LEWTSDIG.I0001.A001 RETAINED
> DDNAME=SYSUT1
> and a lot of
> DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00000000. "
> DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00000001. "
> DSN1990I DSN1COMP BROKEN PAGE. PAGENUMBER = 00404040. " REASON: NOT-FILE
> BIT
> ON.
> SERVIVE INFO: CODE= 'C03X' PGFLAGS='40'X
> and so on.
>
> Could it be that the SIZE parameter must have another value than the shown
> 1024 ?
>
> But what is the right value in this case ? 32768 ?
>
> Thanks for any help.
>
> With kind regards - mit freundlichen Grüssen,
> G e o r g H . P e t e r
> DB2 Data Base Administrator c/o
> -------------------------------------------------------------------
> Datenzentrale Baden-Wuerttemberg
> Software Development & Technology Center
> Knowlegde Center Database Systems
> Krailenshaldenstrasse 44, 70469 Stuttgart, Germany
> e:mail [login to unmask email]
> Phone 0049-711-8108-271
> PC-Fax 004971189696071
> Internet (only in german language):http://www.dzbw.de
> ----------------------------------------------------------------------
>
> "Keep it simple if you can, but go complex whenever you can't go simple!"
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]
>
>
>
> http://www.ryci.com/db2-l. The owners of the list can be reached at
> [login to unmask email]
----------------------------------------------------------------------------
-------------------------------------------------------------
----------------------------------------------------------------------------
-------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use
of the intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by reply
e-mail and
destroy all copies of the original message. Any unauthorised review, use,
disclosure,
dissemination, forwarding, printing or copying of this email or any action
taken in
reliance on this e-mail is strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com
----------------------------------------------------------------------------
------------------------------------------------------------
----------------------------------------------------------------------------
------------------------------------------------------------