EGL: Handling DB2 sqlcode:-904

Recently I have come across an sql error while trying to execute a sql in DB2 version 7 from web application. The application is developed in Enterprise Generation Language (EGL). The query retrieves huge result set of around 14000 rows. The sql error reads as "UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000302, AND RESOURCE NAME ....[sqlstate:57011][sqlcode:-904]". However the same sql is executed successfully from DB2 SQL client.

After lot of R&D, we tried to set isolation level in the SQL. By default db2 is set to Repeatable Read (RR) level. We have changed this level to Uncommitted Read (UR). Great it works.

Example

Select * from Emp order by empName WITH UR;

Regards

Monu

Earn Money Online

Now you can increase your revenue by taking part in online free surveys. At this recession period when everyone wants to save each cent they earn; people are looking for alternative ways to increase their revenue. And that's the demand of the situation. This information is to share with you guys that online surveys are of the easiest way in this regard. I have tried couple of such organization who offers online surveys. A few shortlisted organizations are listed below (use the link to join). REMEMBER YOU CAN JOIN ALL THESE ORGANIZATIONS AT FREE OF COST.

1. Opinion India : Join Now
2. Ciao-Survey : Join Now
3. Spidermetrix:
   Spidermetrix is an Australia based website which pays you to participate in paid surveys, polls and to evaluate websites. There are also short single question surveys on the site where you earn one point. Sometimes they send well paying surveys to Indian members. Members are called spiders and they earn spider points as rewards. They also give you rewards for referring friends. Payment is by paypal when your account balance reaches the equivalent of $20. Join Spidermetrix here
4. Planet Pulse:
   
   

   Get paid for your opinions! Click on the banner above to join Planet Pulse. Its totally free to sign up, and you can earn UNLIMITED. Find out more by visiting PLANET PULSE.

5. Survey Savvy:
   
   
   
6. Global Test Market: