unavailable resource

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

unavailable resource

Post by admin »

I am trying to do some DB2 loads, and keep getting the following error:

[IBM][CLI Driver][DB2] SQL0904N Unsuccessful execution caused by an
unavailable resource. Reason code: "00D70014", type of resource:
"00000200", and resource name: "VJDBPPLE.VJTSCLHS
". SQLSTATE=57011

I usually get "unavailable resource" errors when the table is locked or
such, but that doesn't seem to be the case here at all.


Eric
----------
"Imagination is more important than knowledge. Knowledge is limited.
Imagination circles the world."
- Albert Einstein




_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

unavailable resource

Post by admin »

Hi Eric,

We were getting similar errors. It was happening during our dynamic pack
backups/reorgs on our DB2 Disk packs where the DB2 tables live.
To get around this we had to re-schedule our jobs around these Pack backups
to avoid the problem.
Basically DB2 cannot access the linear dataset that is required for your
request during this time.

Hope this helps

Chris


> -----Original Message-----
> From: Eric.Roufs@stpaul.com [SMTP:Eric.Roufs@stpaul.com]
> Sent: Saturday, February 21, 2004 6:35 AM
> To: DataStage Users Discussion List
> Subject: unavailable resource
>
>
> I am trying to do some DB2 loads, and keep getting the following error:
>
> [IBM][CLI Driver][DB2] SQL0904N Unsuccessful execution caused by an
> unavailable resource. Reason code: "00D70014", type of resource:
> "00000200", and resource name: "VJDBPPLE.VJTSCLHS
> ". SQLSTATE=57011
>
> I usually get "unavailable resource" errors when the table is locked or
> such, but that doesn't seem to be the case here at all.
>
>
> Eric
> ----------
> "Imagination is more important than knowledge. Knowledge is limited.
> Imagination circles the world."
> - Albert Einstein
>
>
>
>
> _______________________________________________
> datastage-users mailing list
> datastage-users@oliver.com
> http://www.oliver.com/mailman/listinfo/datastage-users


-----------------------------------------------------------------------------------

The contents of this message are the views of the Author and do not necessarily reflect the views of SUNCORP METWAY LTD ABN 66 010 831 722.

The content of this e-mail, including attachments is a confidential communication between the Suncorp Metway Group and the intended addressee. Any unauthorised use of the contents is expressly prohibited. If you have received this e-mail in error please contact the sender immediately and then delete the message and any attachment(s).

http://www.suncorp.com.au

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Locked