|
View previous topic :: View next topic
|
| Author |
Message |
venkad1110
New User
Joined: 23 Feb 2005
Posts: 7
|
|
|
|
When i try to do a select on a table X which is having 16M Rows I'm getting the below error, could someone can help me on this.
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00C90084, TYPE OF RESOURCE 00000230, AND RESOURCE NAME 4K
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
use the IBM LookAt Site and enter -904
you can also enter DSNT408I and follow the links. |
|
| Back to top |
|
|
suyerasi
New User
Joined: 05 Apr 2007
Posts: 38
Location: india
|
|
|
|
| check the status of the table space that you are running against using the Display command |
|
| Back to top |
|
|
suresh1624
New User
Joined: 21 Nov 2007
Posts: 28
Location: chennai
|
|
|
|
| can you post the query u tried? also please post the what is the primary index for your table. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| suyerasi wrote: |
| check the status of the table space that you are running against using the Display command |
| suresh1624 wrote: |
| can you post the query u tried? also please post the what is the primary index for your table. |
I know that you both are trying to help the TS with his problem.
But, none of this will help resolving this particular -904.
Please refer to the 'Problem' and 'Action' as documented in the manuals. |
|
| Back to top |
|
|
|
|
