View previous topic :: View next topic
|
Author |
Message |
Furor
New User
Joined: 04 Jun 2009 Posts: 30 Location: Bangalore
|
|
|
|
Hi,
I was running a load job on my table. The job failed stating that
Code: |
UTILITY IS NOT COMPATIBLE WITH THE LOAD UTILITY
UTILID = ABCD, OBJECT = XYZ |
When I terminated the utility ABCD. I re ran the job and it gave.
Code: |
SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE
RESOURCE 00000200, AND RESOURCE NAME XYZ |
When I tried to display XYZ on command line ...it didn't appear...when I went to browse it stated No entry for the object.
I did run
Code: |
REPAIR SET TABLESPACE XYZ NORCVRPEND
REPAIR SET TABLESPACE XYZ NOCOPYPEND |
Still , there I coudn't see the table for Browse or edit...and there is no Utility active.
Please suggest.
Thanks |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Furor,
By using the term Browse or Edit for a table, can i guess you are using Platinum Tool,
Use the following command to see what is the status of the table
Code: |
-Display database(dbname) spacenam(*) limit(*) |
Let us know what you see ? And you need to be a lot more descriptive...
Sushanth |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Resource type 200 is table space ... What is the status of the table space ?
Anyways your job failed even before the first step of LOAD so it might not be in UTUT state. which utility were you using for LOAD ?
I dont understand how the TS dissappeared while loading ? |
|
Back to top |
|
|
|