Topic
  • 2 replies
  • Latest Post - ‏2014-08-14T09:09:17Z by mor
e0594cn
e0594cn
5 Posts

Pinned topic Error:SQL0901N when access one table

‏2014-08-12T15:02:58Z |
Hi,
Recently i want to try to access one table in db2 9.7. It will come out the 
 
below error:
 
com.ibm.db.DataException: A database manager error occurred.
: [IBM][CLI Driver][DB2/NT64] SQL0901N  The SQL statement failed
because of a non-severe system error. Subsequent SQL statements can
be processed.  (Reason "Specified index not found for scan open".)
SQLSTATE=58004
 
 
And also refer to below error coming from db2diag.log when i access the table:
 
2014-08-12-17.52.08.866000+480 I35784932F1196     LEVEL: Severe
PID     : 3380                 TID  : 2676        PROC : db2syscs.exe
INSTANCE: DB2DV1               NODE : 000         DB   : DV1
APPHDL  : 0-127                APPID: *LOCAL.DB2DV1.140812095207
AUTHID  : DB2DV1 
EDUID   : 2676                 EDUNAME: db2agent (DV1) 0
FUNCTION: DB2 UDB, data management, sqldSetupIndexScan, probe:1873
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
          "non-severe dms programming error"
          DIA8532C An internal processing error has occurred.
DATA #1 : String, 39 bytes
Specified index not found for scan open
DATA #2 : String, 12 bytes
sqldScanOpen
CALLSTCK:
  [0] 0x000000018010E989 pdLog + 0x353
  [1] 0x0000000003ABE3C2 sqlzSetAndLog901 + 0x192
  [2] 0x0000000001E61F01 sqldSetupIndexScan + 0xF37
  [3] 0x0000000001E5F5CC sqldScanOpen + 0xBEE
  [4] 0x000000000334F460 sqlriopn + 0x316
  [5] 0x00000000034AE788 sqlritaSimplePerm + 0x252
  [6] 0x000000000336AC8B sqlriSectInvoke + 0x139
  [7] 0x00000000030A6F0C sqlrr_process_fetch_request + 0x1A8
  [8] 0x00000000030A2902 sqlrr_open + 0x534
  [9] 0x000000000223FCCB sqljs_ddm_opnqry + 0x447
 
 
2014-08-12-17.52.08.866000+480 I35786130F533      LEVEL: Error
PID     : 3380                 TID  : 2676        PROC : db2syscs.exe
INSTANCE: DB2DV1               NODE : 000         DB   : DV1
APPHDL  : 0-127                APPID: *LOCAL.DB2DV1.140812095207
AUTHID  : DB2DV1 
EDUID   : 2676                 EDUNAME: db2agent (DV1) 0
FUNCTION: DB2 UDB, data management, sqldSetupIndexScan, probe:1873
DATA #1 : unsigned integer, 4 bytes
10
DATA #2 : unsigned integer, 4 bytes
1704
DATA #3 : unsigned integer, 2 bytes
 
Any suggestion.
  • e0594cn
    e0594cn
    5 Posts

    Re: Error:SQL0901N when access one table

    ‏2014-08-14T01:28:39Z  

    Hi,
    Update something.

    1) I have used the db2dart /db to scan the database name & didn't find any affected objects.
     
    The result from log file is all operation completed without error, no problems were detected in the database.
     
     2) I also use the db2dart /MI to mark the index as invalid and restart the database to proceed  RESTART RECREATE INDEX.
     
    But, the result is the same.
     
    So, i also try to reorganize index for this table:BTCCTL ,i will come out the below error:
     
    QL0404N  A string in the UPDATE or INSERT statement is too long 
    for column "DV1#BTABI".
     
    Explanation: 
     
    An INSERT or UPDATE statement specifies a value that is longer than the
    maximum-length string that can be stored in the column indicated.
     
     
    The statement cannot be processed.
  • mor
    mor
    577 Posts

    Re: Error:SQL0901N when access one table

    ‏2014-08-14T09:09:17Z  
    • e0594cn
    • ‏2014-08-14T01:28:39Z

    Hi,
    Update something.

    1) I have used the db2dart /db to scan the database name & didn't find any affected objects.
     
    The result from log file is all operation completed without error, no problems were detected in the database.
     
     2) I also use the db2dart /MI to mark the index as invalid and restart the database to proceed  RESTART RECREATE INDEX.
     
    But, the result is the same.
     
    So, i also try to reorganize index for this table:BTCCTL ,i will come out the below error:
     
    QL0404N  A string in the UPDATE or INSERT statement is too long 
    for column "DV1#BTABI".
     
    Explanation: 
     
    An INSERT or UPDATE statement specifies a value that is longer than the
    maximum-length string that can be stored in the column indicated.
     
     
    The statement cannot be processed.

    If this is a SAP installation, you should progress with ticket via the SAP portal.

    If this is not SAP then open a PMR with IBM.