SYSMAP requirement question

Scott Taylor

SYSMAP requirement question
DB2 V7.1

In the Utility guide under LOAD, there are two requirements listed for the
SYSMAP DD. One is when referential constraints exist and
ENFORCE(CONSTRAINTS) is specified... and the other is worded as "If you
request discard processing when loading one or more tables that have unique
indexes".

Is it possible to NOT request discard processing? DISCARDS value either
defaults to 0, which means all records *could* be discarded, or you specify
a limit. Either way discard processing is enabled, right? If you cannot
avoid discard processing, shouldn't this particular requirement's wording
simply state that this DD is required if your table contains unique
indexes?

What am I missing, besides possibly needing another cup of coffee?
Thanks.
----------------------------------------------------------------------------------------------------

Scott Taylor
Senior DB2 DBA, Autozone
123 S Front St, Memphis, TN 38103
(901)/495-7797

------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.

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

SYSMAP requirement question
(in response to Scott Taylor)
Scott,

It is possible to tell the load utility to skip discard processing. The
utility will still reject input records when appropriate. It just will not
write them to a data set.

I knew what information I was seeking in the manual. It still took me a
while to find it. It is buried in the fine print. From the options
description section under the load utility:
<snip>
If you omit the DISCARDDN option, the utility application program saves
discarded records only if there is a SYSDISC DD statement in the JCL input.
<endsnip>

So to disable discard processing:
1. do not specify DISCARDDN on the load utility control statement
2. omit the SYSDISC DD statement in the JCL

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

Scott Taylor

Re: SYSMAP requirement question
(in response to Mark McCormack)
Ahhh... thanks Mark. It was the existence of the SYSDISC DD that was still
causing DISCARD processing to be active. It was right there in print and I
didn't catch it - so my apologies for posting this.

Thanks again, have a nice day.
----------------------------------------------------------------------------------------------------

Scott Taylor
Senior DB2 DBA, Autozone
123 S Front St, Memphis, TN 38103
(901)/495-7797




[login to unmask email]
STREET.COM To: [login to unmask email]
Sent by: DB2 Data cc:
Base Discussion Subject: SYSMAP requirement question
List
<[login to unmask email]
ORG>


01/14/2004 09:24
AM
Please respond to
DB2 Database
Discussion list
at IDUG






Scott,

It is possible to tell the load utility to skip discard processing. The
utility will still reject input records when appropriate. It just will not
write them to a data set.

I knew what information I was seeking in the manual. It still took me a
while to find it. It is buried in the fine print. From the options
description section under the load utility:
<snip>
If you omit the DISCARDDN option, the utility application program saves
discarded records only if there is a SYSDISC DD statement in the JCL input.
<endsnip>

So to disable discard processing:
1. do not specify DISCARDDN on the load utility control statement
2. omit the SYSDISC DD statement in the JCL

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



------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.

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