Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    10

    Unanswered: Unable to allocate new pages...

    All,
    We got one error while generating report from database using Java(JDBC).

    Error shown:
    com.ibm.db2.jcc.b.SQLException: Unable to allocate new pages in table space "TablSPCName".

    Can anyone,please elloborate the reason for the same,and what needful action can be taken ?

    Regards
    Baseet Ahmed

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    seems like the given tablespace is full.
    if DMS you can alter the size of the containers
    For SMS chk if some space can be allocted on given drive to tablespace by moving other folders to some other drive
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Jun 2008
    Posts
    10
    Thank you.
    We have altered the table space, by increasing the size.
    Problem resolved.

    Regards
    Baseet Ahmed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •