View previous topic :: View next topic
|
Author |
Message |
sajjan jindal Warnings : 1 New User
Joined: 09 Sep 2007 Posts: 60 Location: india
|
|
|
|
Hi,
I faced issue while loading data in DB2 Table. I had coded load card as below :
LOAD DATA RESUME YES INDDN SYSREC00 INTO TABLE
Job failed with :
DSNUGBAC - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00C90101'
COMPLETION CODE - SYSTEM=04E USER=0000
In master lof i got following info :
-D2P@ DSNISGNS DATA IN USE DURING ABEND 535
REASON 00C90101
ERQUAL 500B
TYPE 00000302
NAME Databse.Tablespace.X'000FFFFF'
CONNECTION-ID=UTILITY
CORRELATION-ID=RDB170D1
LUW-ID=B1001.CBDB2P@.C62B9D104198=0
Then i had changed load card to :
LOAD DATA REPLACE INDDN SYSREC00 INTO TABLE
Can anyone tell me what can be d issue that Job failed with RESUME YES Option. It was due to full tablespace or what..
Even i had checked Tablespace used. its 99%...
But i m not sure what can be d reson....and wat is d possible solution to avoid that abend with RESUME YES option. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Sajjan,
Quote: |
D2P@ DSNISGNS DATA IN USE DURING ABEND 535 |
So, as the message says, someone must be using that data, when you ran your load.
And for the ABEND 535
Quote: |
SVC 53, which obtains and releases exclusive control of a resource associated with a BDAM data set, issued a GETMAIN for storage to be used in its processing and found no storage was available.
|
Response
Quote: |
Rerun the job. If the problem continues, storage may have to be freed by others before the exclusive control function is used.
|
Sushanth |
|
Back to top |
|
|
sajjan jindal Warnings : 1 New User
Joined: 09 Sep 2007 Posts: 60 Location: india
|
|
|
|
Hi Sushanth,
Thanks for your quick response. I could not understand desc for ABEND 535. It wud be good, if u can illustrate more about this.run job with
I had run job twice with RESUME YES Option, it failed with same error.
Then i had REPLACE option. It ran fine.
So i was wondering why it did not run with RESUME YES Option. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Sajjan,
RESUME YES, appends the data at the end of existing data in the table. And, It does not take into account for rows that have been marked deleted. So, due to insufficient space also might have caused the problem.
While on the other hand, REPLACE deletes the datasets and recreates the DB2 datasets.
It would be helpful to know, if you tell how much of data is already present in the table and how are much of data you tried to append. And what is the size of the tablespace, extents so on....
Or it would be best if you contact your DBA.
Thank You,
Sushanth |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Sushanth,
you have become a very patient, articulate, and knowledgeable member of this forum. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Thank You Very Much Dino,
Everything, so far, I learnt in mainframe are by guidance of members & moderators of this forum.
Sometimes, I might ask stupid questions. But, thank you very much, really for your patience & guidance.
Sushanth |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
There should be an information code DSN* before DSNUGBAC. Can you post that please ? |
|
Back to top |
|
|
|