View previous topic :: View next topic
|
Author |
Message |
gopalkulkarni
New User
Joined: 13 Aug 2007 Posts: 12 Location: Pune, India
|
|
|
|
Hi,
I was loading data into table using batchjob.
While loading data, I encountered error.
Error message was 'Resource unavailable on Index.'
If I run reorg on Index for this table, index will be available for loading data or not?
Please reply to my query.
Regards,
Gopal |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
I am not DBA but it would help if you post exact error message with error code in the spool... |
|
Back to top |
|
|
gopalkulkarni
New User
Joined: 13 Aug 2007 Posts: 12 Location: Pune, India
|
|
|
|
Error message is given below :
_______________________________________________________________
ERROR LOADING INDEX, ERROR = X'00E40322', INDEX = region.indexname
DSNUGSAT - RESOURCE UNAVAILABLE
REASON 00D70014
TYPE 00000220
NAME DAUG.DSNDBC.DDW6DOMI.XDWDAGY1.J0001.A001
DSNUGSAT - UTILITY DATA BASE SERVICES MEMORY EXECUTION ABENDED, REASON=X'00E40322' CAUSE=X'00E40322'
DSNUGBAC - UTILITY BATCH MEMORY EXECUTION ABENDED, REASON=X'00E40347'
_______________________________________________________________ |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
most common causes :
index is defined to small (PRIQTY/SECQTY) for the number of rows you're loading |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Check if DAUG.DSNDBC.DDW6DOMI.XDWDAGY1.J0001.A001 is available ?
I think running REORG on TS will probable give the same error; drop and recreate the index. |
|
Back to top |
|
|
|