Results 1 to 5 of 5

Thread: db2expln

  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Red face Unanswered: db2expln

    hi, when i try to fine the expln statement for a query i get this error.

    [db2inst1@WESSPTDW01 ~]$ db2expln -d warehous -t -q 'select * from gems.sca_sum_month'

    DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp. 1991, 2008
    Licensed Material - Program Property of IBM
    IBM DB2 Universal Database SQL and XQUERY Explain Tool

    Error during VALUES for package check.

    Message Text =
    SQL0901N The SQL statement failed because of a non-severe system error.
    Subsequent SQL statements can be processed. (Reason "sqlriResolveOpFunc:
    invalid opcode 0x348 at offset 648:0".) SQLSTATE=58004


    sqlcaid = SQLCA
    sqlcabc = 136
    sqlcode = -901
    sqlstate = 58004
    sqlerrml = 56
    sqlerrmc = "sqlriResolveOpFunc: invalid opcode 0x348 at offset 648:0"
    sqlerrp = SQLRI007
    sqlerrd0 = 0x801A006D = -2145779603
    sqlerrd1 = 0x00000000 = 0
    sqlerrd2 = 0x00000000 = 0
    sqlerrd3 = 0x00000000 = 0
    sqlerrd4 = 0xFFFFFCCC = -820
    sqlerrd5 = 0x00000000 = 0
    sqlwarn = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '

    [db2inst1@WESSPTDW01 ~]$

    Since it has told error during the package values check.

    So i try to bind the package. But it also end up in error.

    [db2inst1@WESSPTDW01 ~]$ db2 bind @db2ubind.lst blocking all grant public

    LINE MESSAGES FOR db2ubind.lst
    ------ --------------------------------------------------------------------
    SQL0061W The binder is in progress.
    SQL0031C File "/home/db2inst1/db2ubind.lst" could not be
    opened. SQLSTATE=00000
    SQL0082C An error has occurred which has terminated
    processing.
    SQL0092N No package was created because of previous errors.
    SQL0091N Binding was ended with "3" errors and "0" warnings.
    [db2inst1@WESSPTDW01 ~]$


    Kindly help me

  2. #2
    Join Date
    Nov 2011
    Posts
    334
    Have you run into wrong path?
    db2ubind.lst is in dir : ${HOME}/sqllib/bnd ...

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    Again the same error even trying in /$dir/sqllib/bnd path..


    [db2inst1@WESSSTDW01 bnd]$ db2 bind @db2ubind.lst blocking all grant public

    LINE MESSAGES FOR db2ubind.lst
    ------ --------------------------------------------------------------------
    SQL0061W The binder is in progress.

    LINE MESSAGES FOR db2ueiwi.bnd
    ------ --------------------------------------------------------------------
    2239 SQL0204N "SYSTEM.SYSUSERAUTH" is an undefined name.
    SQLSTATE=42704
    2243 SQL0204N "SYSTEM.SYSUSERAUTH" is an undefined name.
    SQLSTATE=42704

    LINE MESSAGES FOR db2clpnc.bnd
    ------ --------------------------------------------------------------------
    SQL0595W Isolation level "NC" has been escalated to "UR".
    SQLSTATE=01526

    LINE MESSAGES FOR db2arxnc.bnd
    ------ --------------------------------------------------------------------
    SQL0595W Isolation level "NC" has been escalated to "UR".
    SQLSTATE=01526

    LINE MESSAGES FOR db2ats_sps.bnd
    ------ --------------------------------------------------------------------
    1173 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1203 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1234 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1482 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1499 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1517 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1555 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1679 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1696 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1715 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1732 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1895 SQL0204N "SYSTOOLS.ADMINTASKSTATUS" is an undefined name.
    SQLSTATE=01532
    1950 SQL0204N "SYSTOOLS.ADMINTASKSTATUS" is an undefined name.
    SQLSTATE=01532
    1962 SQL0204N "SYSTOOLS.ADMINTASKS" is an undefined name.
    SQLSTATE=01532
    1979 SQL0204N "SYSTOOLS.ADMINTASKSTATUS" is an undefined name.
    SQLSTATE=01532

    LINE MESSAGES FOR db2adminotm.bnd
    ------ --------------------------------------------------------------------
    342 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
    SQLSTATE=01532
    371 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
    SQLSTATE=01532
    455 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
    SQLSTATE=01532
    536 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
    SQLSTATE=01532
    570 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
    SQLSTATE=01532
    590 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
    SQLSTATE=01532
    671 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
    SQLSTATE=01532
    767 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
    SQLSTATE=01532
    903 SQL0204N "SYSTOOLS.ADMIN_MOVE_TABLE" is an undefined name.
    SQLSTATE=01532

    LINE MESSAGES FOR db2ubind.lst
    ------ --------------------------------------------------------------------
    SQL0091N Binding was ended with "0" errors and "28"
    warnings.
    [db2inst1@WESSSTDW01 bnd]$


    do i need to create any of these tables ?

  4. #4
    Join Date
    Jan 2010
    Posts
    335
    No, everything is fine.
    These are just warnings.

  5. #5
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    if these are just warning,

    when i try for the explain statement again, i am ending with same error only.

    Just tell me how do i overcome this

    [db2inst1@WESSPTDW01 bnd]$ db2expln -database warehous -q 'select * from gems.pacasset_sum_month' -t

    DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp. 1991, 2008
    Licensed Material - Program Property of IBM
    IBM DB2 Universal Database SQL and XQUERY Explain Tool

    Error during VALUES for package check.

    Message Text =
    SQL0901N The SQL statement failed because of a non-severe system error.
    Subsequent SQL statements can be processed. (Reason "sqlriResolveOpFunc:
    invalid opcode 0x348 at offset 648:0".) SQLSTATE=58004


    sqlcaid = SQLCA
    sqlcabc = 136
    sqlcode = -901
    sqlstate = 58004
    sqlerrml = 56
    sqlerrmc = "sqlriResolveOpFunc: invalid opcode 0x348 at offset 648:0"
    sqlerrp = SQLRI007
    sqlerrd0 = 0x801A006D = -2145779603
    sqlerrd1 = 0x00000000 = 0
    sqlerrd2 = 0x00000000 = 0
    sqlerrd3 = 0x00000000 = 0
    sqlerrd4 = 0xFFFFFCCC = -820
    sqlerrd5 = 0x00000000 = 0
    sqlwarn = ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' '

    [db2inst1@WESSPTDW01 bnd]$

Posting Permissions

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