DB2 SQL CODE -904 Explainations

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
swadhend
Member
Posts: 6
Joined: Mon Jan 28, 2008 3:06 pm

DB2 SQL CODE -904 Explainations

Post by swadhend » Thu Mar 13, 2008 10:07 am

Hi ,

Is anybody help me in following SQL CODE.

SQLCODE = -904, UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE.
REASON 00C20110: DB2 cannot access a table space, index, or partition because the highest formatted page (as recorded by DB2 in the header page) is higher than that derived from the VSAM high-used RBA.

I need following explaination

So, what is highest t formatted page (as recorded by DB2 in the header page) in simply words,

what is VSAm , what RBA and how does it work together?

Please try to explain in such a way that a non technican can understand.


swadhend
Member
Posts: 6
Joined: Mon Jan 28, 2008 3:06 pm

Re: DB2 SQL CODE -904 Explainations

Post by swadhend » Thu Mar 13, 2008 1:30 pm

swadhend wrote:Hi ,

Is anybody help me in following SQL CODE.

SQLCODE = -904, UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE.
REASON 00C20110: DB2 cannot access a table space, index, or partition because the highest formatted page (as recorded by DB2 in the header page) is higher than that derived from the VSAM high-used RBA.

I need following explaination

So, what is highest t formatted page (as recorded by DB2 in the header page) in simply words,

what is VSAm , what RBA and how does it work together?

Please try to explain in such a way that a non technican can understand.


Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others