IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Error on positioned delete of multiple fetch


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kalaikala

New User


Joined: 21 Jul 2007
Posts: 27
Location: Chennai

PostPosted: Fri Mar 20, 2009 2:46 pm
Reply with quote

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
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Fri Mar 20, 2009 5:12 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Fri Mar 20, 2009 8:11 pm
Reply with quote

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
View user's profile Send private message
kalaikala

New User


Joined: 21 Jul 2007
Posts: 27
Location: Chennai

PostPosted: Mon Mar 23, 2009 9:08 am
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Mon Mar 23, 2009 10:04 am
Reply with quote

Hello,

You're welcome icon_smile.gif

Suggest you work with your dba and storage management people so that active database data is not migrated. . .
Back to top
View user's profile Send private message
ovreddy

Active User


Joined: 06 Dec 2004
Posts: 211
Location: Keane Inc., Minneapolis USA.

PostPosted: Thu Mar 26, 2009 2:23 am
Reply with quote

Hi Kalai,

Provide me with reason code along with -904 so that I can determine the exact cause.

Thanks,
Reddy
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Thu Mar 26, 2009 2:46 am
Reply with quote

Hello,

Please re-read the replies - the answer is already given. . .
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1248
Location: Richfield, MN, USA

PostPosted: Thu Mar 26, 2009 5:35 am
Reply with quote

dick scherrer wrote:
Hello,

What is "a powerful User_ID".

Maybe like Jose Canseco or Barry Bonds or Alex Rodriguez? icon_lol.gif
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Thu Mar 26, 2009 3:55 pm
Reply with quote

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. icon_lol.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Thu Mar 26, 2009 4:04 pm
Reply with quote

anandinmainframe wrote:
Are they (Jose Canseco or Barry Bonds or Alex Rodriguez) Powerful people in the world. icon_lol.gif
José Canseco Capas, Jr. (born July 2, 1964 in Havana, Cuba) is a former outfielder and designated hitter in Major League Baseball, and is the identical twin brother of former major league player Ozzie Canseco. Search in google for others . . . icon_razz.gif
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Thu Mar 26, 2009 4:18 pm
Reply with quote

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. icon_cool.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Mar 26, 2009 4:32 pm
Reply with quote

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
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1248
Location: Richfield, MN, USA

PostPosted: Thu Mar 26, 2009 7:22 pm
Reply with quote

To clarify, Jose, Barry, and Alex are either alleged or admitted steroid users!
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix

PostPosted: Thu Mar 26, 2009 8:53 pm
Reply with quote

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. . . icon_confused.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Help on IMS -API URL migrating from P... IMS DB/DC 1
No new posts combine multiple unique records into ... DFSORT/ICETOOL 2
No new posts JES datasets IO Error ABENDS & Debugging 3
No new posts Error to invoke MPP program through B... IMS DB/DC 3
No new posts SORT JCL to merge multiple tow into s... DFSORT/ICETOOL 6
Search our Forums:

Back to Top