Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Error on positioned delete of multiple fetch

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Error on positioned delete of multiple fetch
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    Post subject: Reply to: Error on positioned delete of multiple fetch
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

Site Director


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

PostPosted: Fri Mar 20, 2009 8:11 pm    Post subject:
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    Post subject: Reply to: Error on positioned delete of multiple fetch
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

Site Director


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

PostPosted: Mon Mar 23, 2009 10:04 am    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Thu Mar 26, 2009 2:46 am    Post subject:
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: 1238
Location: Richfield, MN, USA

PostPosted: Thu Mar 26, 2009 5:35 am    Post subject:
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    Post subject: Reply to: Error on positioned delete of multiple fetch
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

Senior Member


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

PostPosted: Thu Mar 26, 2009 4:04 pm    Post subject: Re: Reply to: Error on positioned delete of multiple fetch
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    Post subject: Reply to: Error on positioned delete of multiple fetch
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Mar 26, 2009 4:32 pm    Post subject: Reply to: Error on positioned delete of multiple fetch
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: 1238
Location: Richfield, MN, USA

PostPosted: Thu Mar 26, 2009 7:22 pm    Post subject:
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

Site Director


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

PostPosted: Thu Mar 26, 2009 8:53 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us