View previous topic :: View next topic
|
Author |
Message |
kalaikala
New User
Joined: 21 Jul 2007 Posts: 27 Location: Chennai
|
|
|
|
I am using cursor as below
“Declare cursor C1
rowset positioning
with hold for
Select columns-list from table-name
for update .. ”
“ DELETE FROM table-name
WHERE CURRENT OF C1 FOR ROW :IDX OF ROWSET“
or
“ DELETE FROM table-name
WHERE CURRENT OF C1 “
I am getting error on positioned delete on multiple fetch. The SQLCODE=-904 ie unavailable resource (showing table space name). I am fetching 100 rows at a time and I am getting error after processing few rows. What could be the reason to this?. |
|
Back to top |
|
|
anandinmainframe
Active User
Joined: 31 May 2007 Posts: 171 Location: India
|
|
|
|
kalaikala,
Try submitting from a powerful User_ID or else you need to talk to your support people.
for -904 is
Code: |
-904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE.
|
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
What is "a powerful User_ID".
How would one of these make an unavailable resource available become available?
Probably the most powerful id is the dba and it the resource is unavailable, the dba will also get the -904. . . |
|
Back to top |
|
|
kalaikala
New User
Joined: 21 Jul 2007 Posts: 27 Location: Chennai
|
|
|
|
Hi,
I got solution of this error. My tablespace's VSAM files were in migrate state. I recalled all the files.
Anyway Thanks for your suggestion. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
You're welcome
Suggest you work with your dba and storage management people so that active database data is not migrated. . . |
|
Back to top |
|
|
ovreddy
Active User
Joined: 06 Dec 2004 Posts: 211 Location: Keane Inc., Minneapolis USA.
|
|
|
|
Hi Kalai,
Provide me with reason code along with -904 so that I can determine the exact cause.
Thanks,
Reddy |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
Please re-read the replies - the answer is already given. . . |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1248 Location: Richfield, MN, USA
|
|
|
|
dick scherrer wrote: |
Hello,
What is "a powerful User_ID".
|
Maybe like Jose Canseco or Barry Bonds or Alex Rodriguez? |
|
Back to top |
|
|
anandinmainframe
Active User
Joined: 31 May 2007 Posts: 171 Location: India
|
|
|
|
Hello,
I meant (powerful User_ID) which has the Authorizations to the production region. At times when i get -904 while fetching rows from my id then i will get the ID's from Onsite people the same(Query) will bring a result.
Are they (Jose Canseco or Barry Bonds or Alex Rodriguez) Powerful people in the world. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
Back to top |
|
|
anandinmainframe
Active User
Joined: 31 May 2007 Posts: 171 Location: India
|
|
|
|
Anuj,
How do you (Decide)Know that they are the powerful people in the world.
Anuj wrote:
Quote: |
Search in google for others . . .
|
You can never find that one in Google. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
Quote: |
... will get the ID's from Onsite people ... |
such action might get both of You terminated for lawful reason
if You have the need to know/do/access obtain the proper authorizations from the proper channels |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1248 Location: Richfield, MN, USA
|
|
|
|
To clarify, Jose, Barry, and Alex are either alleged or admitted steroid users! |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
At times when i get -904 while fetching rows from my id then i will get the ID's from Onsite people the same(Query) will bring a result |
A rather ridiculous/dangerous process. . . How does the organization manage/administer this flock of fake yet powerful userids?
To repeat from earlier - using a different id does not make an unavailable resource become available. What kind of unavailablilty is changed by using a different id?
I suspect that while time was being spent getting this magic bullet id, the resource became available. . . |
|
Back to top |
|
|
|