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
 

 

Help required on sqlcode -905

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
viratarya

New User


Joined: 31 Jul 2006
Posts: 1
Location: Delhi

PostPosted: Thu Dec 09, 2010 4:15 pm    Post subject: Help required on sqlcode -905
Reply with quote

How can we Resolve -905

I am trying to load db2 tables from Unix to Mainframe( DB2) and its giving error -905

Unsuccessful Execution due to Resource limit being exceeded
RESOURCE NAME = "ASUTIME" Limit = "000000000045" CPUTIME = "000001800000 Service Time" Derived From "M000.DSNRLST01"
SQLSTATE = 57014


Any help on this will be appreciated
Back to top
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Thu Dec 09, 2010 4:47 pm    Post subject:
Reply with quote

do it in a more performant way or
change the values in M000.DSNRLST01 (<= serious impact)
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 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts FTP help required amitc23 All Other Mainframe Topics 3 Thu Apr 28, 2016 12:02 pm
No new posts Why Newcopy is required when we have ... DIXINSH CICS 5 Thu Apr 28, 2016 9:47 am
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Tricky sort logic required pgopi92 DFSORT/ICETOOL 3 Mon Jan 25, 2016 3:29 pm


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