DSNU255I

Ndt

DSNU255I
Hi all ,

Sometimes , we encoutered DSNU250I message signaling a Key count
inconsistent in sort phase , does any one knows a bit more about this
condition?


Happy Xmas !


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID =
RSTART.IFBZK9A


DSNU050I DSNUGUTC - LOAD LOG NO SORTDEVT
SYSALLDA
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 9 REPLACE INDDN
SYSREC1
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 10 REPLACE INDDN
SYSREC2
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 9
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 10
DSNU364I DSNURPPL - PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER OF
TASKS =
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=1
FOR TAB
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=3
FOR TAB
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS
PROCE
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED
TIME=00:00:04
DSNU042I DSNUGSOR - SORT PHASE STATISTICS -

NUMBER OF
RECORDS=24
ELAPSED
TIME=00:00:06

DSNU255I DSNURSIX - KEY COUNT INCONSISTENT FOR SORT-RD PHASE, NUMBER OF
KEYS
PROCESSED=24





DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'00E4030A
BOTTOM OF LIST -------------------------------------------------------------
----

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

[login to unmask email]

Re: DSNU255I
(in response to Ndt)
Hi,

I think you need to look at the error 00E4030A for more details. Below is
from the manual:

00E4030A
Explanation: A mismatch was found between the total number of keys
processed during the current phase and the total number of keys expected
to be processed in this phase.

System Action: The utility job is abnormally terminated, and all target
objects are placed in rebuild pending state. Message DSNU255I was issued
earlier to report both the keys processed and the keys expected. A dump is
requested.

User Response: TERM the utility and re-access the indexes by running
REPAIR utility to reset the rebuild pending states on indexes. Run the
CHECK INDEX utility to determine if any of the affected indexes are
inconsistent. Inconsistent indexes may be recovered by the REBUILD INDEX
or RECOVER utility.



nguyen
<[login to unmask email]> To: [login to unmask email]
Sent by: DB2 cc:
Data Base Subject: DSNU255I
Discussion List
<[login to unmask email]
.ORG>


12/24/2003 06:06
AM
Please respond
to DB2 Database
Discussion list
at IDUG






Hi all ,

Sometimes , we encoutered DSNU250I message signaling a Key count
inconsistent in sort phase , does any one knows a bit more about this
condition?


Happy Xmas !


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID =
RSTART.IFBZK9A


DSNU050I DSNUGUTC - LOAD LOG NO SORTDEVT
SYSALLDA
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 9 REPLACE INDDN
SYSREC1
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 10 REPLACE INDDN
SYSREC2
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 9
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 10
DSNU364I DSNURPPL - PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER OF
TASKS =
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=1
FOR TAB
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=3
FOR TAB
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS
PROCE
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED
TIME=00:00:04
DSNU042I DSNUGSOR - SORT PHASE STATISTICS -

NUMBER OF
RECORDS=24
ELAPSED
TIME=00:00:06

DSNU255I DSNURSIX - KEY COUNT INCONSISTENT FOR SORT-RD PHASE, NUMBER OF
KEYS
PROCESSED=24





DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'00E4030A
BOTTOM OF LIST
-------------------------------------------------------------
----

---------------------------------------------------------------------------------

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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Sushanta K Dash

Re: DSNU255I
(in response to Ed_Vetock@NAVYFEDERAL.ORG)
Is there a chance that you restarted the utility and done some adjustment to
work files.

With thanks
Dash
____________________________________________________________________________
_____________
DB2 / IMS Database Administration Tel: 91 ( 44 )
28113801. X-2366.
India Solution Center
Fax: 91 (44 ) 28113790.
Chennai.
E-mail : [login to unmask email]
"The views expressed are my own and do not necessarily represent the views
or policy of my employer"



-----Original Message-----
From: DB2 Data Base Discussion List [SMTP:[login to unmask email] On
Behalf Of nguyen
Sent: Wednesday, December 24, 2003 4:36 PM
To: [login to unmask email]
Subject: DSNU255I

Hi all ,

Sometimes , we encoutered DSNU250I message signaling a Key count
inconsistent in sort phase , does any one knows a bit more about
this
condition?


Happy Xmas !


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID =
RSTART.IFBZK9A


DSNU050I DSNUGUTC - LOAD LOG NO SORTDEVT
SYSALLDA
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 9 REPLACE INDDN
SYSREC1
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 10 REPLACE
INDDN
SYSREC2
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 9
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 10
DSNU364I DSNURPPL - PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER
OF
TASKS =
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF
RECORDS=1
FOR TAB
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF
RECORDS=3
FOR TAB
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT
RECORDS
PROCE
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED
TIME=00:00:04
DSNU042I DSNUGSOR - SORT PHASE STATISTICS -

NUMBER OF
RECORDS=24
ELAPSED
TIME=00:00:06

DSNU255I DSNURSIX - KEY COUNT INCONSISTENT FOR SORT-RD PHASE,
NUMBER OF
KEYS
PROCESSED=24





DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'00E4030A
BOTTOM OF LIST
-------------------------------------------------------------
----


----------------------------------------------------------------------------
-----
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". If you will be out of the office, send
the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Rob Hougrand

Re: DSNU255I
(in response to Sushanta K Dash)
From my experience just restarting the utility will cause this
problem... You don't need to adjust the work files

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Dash, Sushanta
Sent: Wednesday, December 24, 2003 6:52 AM
To: [login to unmask email]
Subject: Re: DSNU255I


Is there a chance that you restarted the utility and done some
adjustment to work files.

With thanks
Dash
________________________________________________________________________
____
_____________
DB2 / IMS Database Administration Tel: 91 ( 44
)
28113801. X-2366.
India Solution Center
Fax: 91 (44 ) 28113790.
Chennai.
E-mail : [login to unmask email]
"The views expressed are my own and do not necessarily represent the
views or policy of my employer"



-----Original Message-----
From: DB2 Data Base Discussion List [SMTP:[login to unmask email]
On
Behalf Of nguyen
Sent: Wednesday, December 24, 2003 4:36 PM
To: [login to unmask email]
Subject: DSNU255I

Hi all ,

Sometimes , we encoutered DSNU250I message signaling a Key count
inconsistent in sort phase , does any one knows a bit more about
this
condition?


Happy Xmas !


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID =
RSTART.IFBZK9A


DSNU050I DSNUGUTC - LOAD LOG NO SORTDEVT
SYSALLDA
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 9 REPLACE
INDDN
SYSREC1
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 10 REPLACE
INDDN
SYSREC2
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM
TABLESPACE
PARTITION 9
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM
TABLESPACE
PARTITION 10
DSNU364I DSNURPPL - PARTITIONS WILL BE LOADED IN PARALLEL,
NUMBER
OF
TASKS =
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF
RECORDS=1
FOR TAB
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF
RECORDS=3
FOR TAB
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF
INPUT
RECORDS
PROCE
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED
TIME=00:00:04
DSNU042I DSNUGSOR - SORT PHASE STATISTICS -

NUMBER OF
RECORDS=24
ELAPSED
TIME=00:00:06

DSNU255I DSNURSIX - KEY COUNT INCONSISTENT FOR SORT-RD PHASE,
NUMBER OF
KEYS
PROCESSED=24





DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'00E4030A
BOTTOM OF LIST
-------------------------------------------------------------
----


------------------------------------------------------------------------
----
-----
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". If you will be out of
the office, send the SET DB2-L NO MAIL command to
[login to unmask email] 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". If you will be out of the office,
send the SET DB2-L NO MAIL command to [login to unmask email] 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


This e-mail may contain confidential or privileged information. If you
think you have received this e-mail in error, please advise the sender by
reply e-mail and then delete this e-mail immediately. Thank you. Aetna

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Raymond Bell

Re: DSNU255I
(in response to Rob Hougrand)
Yo nguyen (sorry, don't know your name),

I could be way off base here, but these messages stem from a failed load.
What's happened is, I think, your load has been loading rows into the
tablespace and then failed in the load phase for some reason. You're now
trying to restart the utility (big clue: the utility Id is RSTART.blah-blah)
but haven't preserved the work files from the first execution.

DB2 knows how many index keys it's extracted during the load phase. If,
when it gets to the sort, it finds the actual key count (in the Sysut1 file)
is different to how may DB2 has extracted, you get your error message. When
it's happened to me, it's because I've coded &&-type DD statements for
Sysut1, among others. When the utility failed the first time, the work
files were lost and all DB2's hard work up to that point extracting the keys
is lost. But DB2 doesn't know you've lost the work files; it assumes you
want to carry on - you did code Restart, after all.

Two options. 1) Recover the data to before the load and start again, coding
permanent datasets for sysut1, sortout, etc. Delete them once the job's
competed. Or 2) if you're happy the actual data is OK, -term the utility
and rebuild the dependent indexes from the data you've loaded.

Happy loading,


Raymond
PS. Anyone heard from Mr. Waugh lately?

-----Original Message-----
From: nguyen [mailto:[login to unmask email]
Sent: 24 December 2003 11:06
To: [login to unmask email]
Subject: DSNU255I


Hi all ,

Sometimes , we encoutered DSNU250I message signaling a Key count
inconsistent in sort phase , does any one knows a bit more about this
condition?


Happy Xmas !


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID =
RSTART.IFBZK9A


DSNU050I DSNUGUTC - LOAD LOG NO SORTDEVT
SYSALLDA
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 9 REPLACE INDDN
SYSREC1
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 10 REPLACE INDDN
SYSREC2
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 9
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 10
DSNU364I DSNURPPL - PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER OF
TASKS =
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=1
FOR TAB
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=3
FOR TAB
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS
PROCE
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED
TIME=00:00:04
DSNU042I DSNUGSOR - SORT PHASE STATISTICS -

NUMBER OF
RECORDS=24
ELAPSED
TIME=00:00:06

DSNU255I DSNURSIX - KEY COUNT INCONSISTENT FOR SORT-RD PHASE, NUMBER OF
KEYS
PROCESSED=24





DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'00E4030A
BOTTOM OF LIST -------------------------------------------------------------
----

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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


This e-mail (and any attachments) may contain privileged and/or confidential information. If you are not the intended recipient please do not disclose, copy, distribute, disseminate or take any action in reliance on it. If you have received this message in error please reply and tell us and then delete it. Should you wish to communicate with us by e-mail we cannot guarantee the security of any data outside our own computer systems. For the protection of Legal & General's systems and staff, incoming emails will be automatically scanned.

Any information contained in this message may be subject to applicable terms and conditions and must not be construed as giving investment advice within or outside the United Kingdom.

Representative only of the Legal & General marketing group, members of which are regulated by the Financial Services Authority for the purposes of advising on life assurance and investment products bearing Legal & General's name.
Legal & General Group PLC, Temple Court, 11 Queen Victoria Street, London, EC4N 4TP.
Registered in England no: 166055.

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Sushanta K Dash

Re: DSNU255I
(in response to Raymond Bell)
Hi Raymond, though I had not experienced the scenario like you explained but
slightly disagree with this. May be due to lack of knowledge. Probably you
may be knowing more so that it can rectify me. But I guess with all the
installation DFP is installed and once the DFP is installed it have macros
which enables to reposition during restart and there is no chance of losing
the work-files or its contents. I m having less knowledge about this and can
be rectified by the experts like you.

With thanks

Dash

DB2 / IMS Database Administration Tel: 91 ( 44 )
28113801. X-2366.
India Solution Center Fax: 91 (44 )
28113790.
Chennai.
E-mail : [login to unmask email] Dash
____________________________________________________________________________
_____________
"The views expressed are my own and do not necessarily represent the views
or policy of my employer"

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bell, Raymond
Sent: Monday, 29 December 2003 3:05 PM
To: [login to unmask email]
Subject: Re: DSNU255I

Yo nguyen (sorry, don't know your name),

I could be way off base here, but these messages stem from a failed load.
What's happened is, I think, your load has been loading rows into the
tablespace and then failed in the load phase for some reason. You're now
trying to restart the utility (big clue: the utility Id is RSTART.blah-blah)
but haven't preserved the work files from the first execution.

DB2 knows how many index keys it's extracted during the load phase. If,
when it gets to the sort, it finds the actual key count (in the Sysut1 file)
is different to how may DB2 has extracted, you get your error message. When
it's happened to me, it's because I've coded &&-type DD statements for
Sysut1, among others. When the utility failed the first time, the work
files were lost and all DB2's hard work up to that point extracting the keys
is lost. But DB2 doesn't know you've lost the work files; it assumes you
want to carry on - you did code Restart, after all.

Two options. 1) Recover the data to before the load and start again, coding
permanent datasets for sysut1, sortout, etc. Delete them once the job's
competed. Or 2) if you're happy the actual data is OK, -term the utility
and rebuild the dependent indexes from the data you've loaded.

Happy loading,


Raymond
PS. Anyone heard from Mr. Waugh lately?

-----Original Message-----
From: nguyen [mailto:[login to unmask email]
Sent: 24 December 2003 11:06
To: [login to unmask email]
Subject: DSNU255I


Hi all ,

Sometimes , we encoutered DSNU250I message signaling a Key count
inconsistent in sort phase , does any one knows a bit more about this
condition?


Happy Xmas !


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID =
RSTART.IFBZK9A


DSNU050I DSNUGUTC - LOAD LOG NO SORTDEVT
SYSALLDA
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 9 REPLACE INDDN
SYSREC1
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 10 REPLACE INDDN
SYSREC2
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 9
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 10
DSNU364I DSNURPPL - PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER OF
TASKS =
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=1
FOR TAB
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=3
FOR TAB
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS
PROCE
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED
TIME=00:00:04
DSNU042I DSNUGSOR - SORT PHASE STATISTICS -

NUMBER OF
RECORDS=24
ELAPSED
TIME=00:00:06

DSNU255I DSNURSIX - KEY COUNT INCONSISTENT FOR SORT-RD PHASE, NUMBER OF
KEYS
PROCESSED=24





DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'00E4030A
BOTTOM OF LIST -------------------------------------------------------------
----

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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


This e-mail (and any attachments) may contain privileged and/or confidential
information. If you are not the intended recipient please do not disclose,
copy, distribute, disseminate or take any action in reliance on it. If you
have received this message in error please reply and tell us and then delete
it. Should you wish to communicate with us by e-mail we cannot guarantee the
security of any data outside our own computer systems. For the protection of
Legal & General's systems and staff, incoming emails will be automatically
scanned.

Any information contained in this message may be subject to applicable terms
and conditions and must not be construed as giving investment advice within
or outside the United Kingdom.

Representative only of the Legal & General marketing group, members of which
are regulated by the Financial Services Authority for the purposes of
advising on life assurance and investment products bearing Legal & General's
name.
Legal & General Group PLC, Temple Court, 11 Queen Victoria Street, London,
EC4N 4TP.
Registered in England no: 166055.

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Sushanta K Dash

Re: DSNU255I
(in response to Sushanta K Dash)
Dear Raymond , I understood after a bit research and this is the reason
probably we have been practicing the recovery once there is failure in
reload phase not doing any restart. If you have more answers to this I would
gladly accept that. Restart is possible with consistent record only in
SORTKEY case and in other case it would produce the wrong result. I was
asking why even the DFP is installed why restart of reload phase wont give
correct/consistent data. I checked DFP and it says even the macros are there
to consistent information in files but it is the not responsibilities of Db2
or MVS. So the internal commit may not be intact. This could be the possible
reason that even though DFP is installed and we restart the load failed at
RELOAD phase would produce inconsistent data. This is the reason we are not
going for restart in reload phase. Probably you may other answer.

With thanks

Dash

DB2 / IMS Database Administration Tel: 91 ( 44 )
28113801. X-2366.
India Solution Center Fax: 91 (44 )
28113790.
Chennai.
E-mail : [login to unmask email] Dash
____________________________________________________________________________
_____________
"The views expressed are my own and do not necessarily represent the views
or policy of my employer"

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Bell, Raymond
Sent: Monday, 29 December 2003 3:05 PM
To: [login to unmask email]
Subject: Re: DSNU255I

Yo nguyen (sorry, don't know your name),

I could be way off base here, but these messages stem from a failed load.
What's happened is, I think, your load has been loading rows into the
tablespace and then failed in the load phase for some reason. You're now
trying to restart the utility (big clue: the utility Id is RSTART.blah-blah)
but haven't preserved the work files from the first execution.

DB2 knows how many index keys it's extracted during the load phase. If,
when it gets to the sort, it finds the actual key count (in the Sysut1 file)
is different to how may DB2 has extracted, you get your error message. When
it's happened to me, it's because I've coded &&-type DD statements for
Sysut1, among others. When the utility failed the first time, the work
files were lost and all DB2's hard work up to that point extracting the keys
is lost. But DB2 doesn't know you've lost the work files; it assumes you
want to carry on - you did code Restart, after all.

Two options. 1) Recover the data to before the load and start again, coding
permanent datasets for sysut1, sortout, etc. Delete them once the job's
competed. Or 2) if you're happy the actual data is OK, -term the utility
and rebuild the dependent indexes from the data you've loaded.

Happy loading,


Raymond
PS. Anyone heard from Mr. Waugh lately?

-----Original Message-----
From: nguyen [mailto:[login to unmask email]
Sent: 24 December 2003 11:06
To: [login to unmask email]
Subject: DSNU255I


Hi all ,

Sometimes , we encoutered DSNU250I message signaling a Key count
inconsistent in sort phase , does any one knows a bit more about this
condition?


Happy Xmas !


DSNU000I DSNUGUTC - OUTPUT START FOR UTILITY, UTILID =
RSTART.IFBZK9A


DSNU050I DSNUGUTC - LOAD LOG NO SORTDEVT
SYSALLDA
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 9 REPLACE INDDN
SYSREC1
DSNU650I DR06 DSNURWI - INTO TABLE EI.FBA600 PART 10 REPLACE INDDN
SYSREC2
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 9
DSNU352I DR06 DSNURRST - EXISTING RECORDS DELETED FROM TABLESPACE
PARTITION 10
DSNU364I DSNURPPL - PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER OF
TASKS =
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=1
FOR TAB
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=3
FOR TAB
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS
PROCE
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED
TIME=00:00:04
DSNU042I DSNUGSOR - SORT PHASE STATISTICS -

NUMBER OF
RECORDS=24
ELAPSED
TIME=00:00:06

DSNU255I DSNURSIX - KEY COUNT INCONSISTENT FOR SORT-RD PHASE, NUMBER OF
KEYS
PROCESSED=24





DSNU016I DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED,
REASON=X'00E4030A
BOTTOM OF LIST -------------------------------------------------------------
----

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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


This e-mail (and any attachments) may contain privileged and/or confidential
information. If you are not the intended recipient please do not disclose,
copy, distribute, disseminate or take any action in reliance on it. If you
have received this message in error please reply and tell us and then delete
it. Should you wish to communicate with us by e-mail we cannot guarantee the
security of any data outside our own computer systems. For the protection of
Legal & General's systems and staff, incoming emails will be automatically
scanned.

Any information contained in this message may be subject to applicable terms
and conditions and must not be construed as giving investment advice within
or outside the United Kingdom.

Representative only of the Legal & General marketing group, members of which
are regulated by the Financial Services Authority for the purposes of
advising on life assurance and investment products bearing Legal & General's
name.
Legal & General Group PLC, Temple Court, 11 Queen Victoria Street, London,
EC4N 4TP.
Registered in England no: 166055.

----------------------------------------------------------------------------
-----
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". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

David S Waugh

Re: DSNU255I
(in response to Sushanta K Dash)
-- "Bell, Raymond" <[login to unmask email]> wrote:
[Snip]

PS. Anyone heard from Mr. Waugh lately?


ZZZZZZZZZZZZZZZZZZZZ...Snort! Huh? Wazzit? WhereamI?

Oh, sorry -- must have fallen asleep last time I crawled back under my rock... Thanks for wakin' me up Raymond -- would've slept right through New Year's Eve if it hadn't been for you!

nguyen: On the DSNU255I topic,

It seems you reloaded 1 row into one table and 3 rows into another table, but unloaded a total of 24 index keys. Does this mean you have multiple indexes per table? Hard to tell exactly what happened, as your pasted messages are cut off on the right hand side - especially "Number of records processed" for the DSNU302I message - that would have told us something.

DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=1
FOR TAB
DSNU303I DR06 DSNURWT - (RE)LOAD PHASE STATISTICS - NUMBER OF RECORDS=3
FOR TAB
DSNU302I DSNURILD - (RE)LOAD PHASE STATISTICS - NUMBER OF INPUT RECORDS PROCE
DSNU300I DSNURILD - (RE)LOAD PHASE COMPLETE, ELAPSED
TIME=00:00:04
DSNU042I DSNUGSOR - SORT PHASE STATISTICS -
NUMBER OF RECORDS=24

Can you tell us exactly what the job failed with, and exactly how you tried to restart it? How many index keys SHOULD it have tried to sort and rebuild? Have you tried running CHECK DATA and CHECK INDEX against the tablespace(s) and index(es) to see if there's anything wrong with them?


Ah, well -- Back to my comfy rock!

David Waugh, DE (Dinosaur Extraordinaire)
DSW Consulting & Services

_.-_
__.' o "-.
___----"" ,,,'
__--" _-_ ^^;
____--"" ___ _-\" `""
..--===-------""" "( __-" ,}
.'_/"\
.'/" `\`._
"-_c " '





________________________________________________________________
The best thing to hit the internet in years - Juno SpeedBand!
Surf the web up to FIVE TIMES FASTER!
Only $14.95/ month - visit www.juno.com to sign up today!

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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