Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Load Issue

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Wed Jun 23, 2010 2:01 pm    Post subject: DB2 Load Issue
Reply with quote

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
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jun 23, 2010 7:46 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sajjan jindal
Warnings : 1

New User


Joined: 09 Sep 2007
Posts: 60
Location: india

PostPosted: Wed Jun 23, 2010 9:00 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jun 23, 2010 9:13 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Wed Jun 23, 2010 9:17 pm    Post subject:
Reply with quote

Sushanth,

you have become a very patient, articulate, and knowledgeable member of this forum.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Jun 23, 2010 10:36 pm    Post subject:
Reply with quote

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
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Thu Jun 24, 2010 5:33 pm    Post subject:
Reply with quote

There should be an information code DSN* before DSNUGBAC. Can you post that please ?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am
No new posts Can DFSPARM override SORTKEYS paramet... ashek15 DB2 2 Tue Jan 31, 2017 11:36 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us