IBM Support

IZ31418: SQL20139 (-20139) APPEARS IN DB2DIAG.LOG WHEN INTERRUPTING QUERY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL20139 (-20139) appears in db2diag.log when interrupting
    stored procedure call which needs to access a table which has
    been locked in exclusive mode.
    
    
    Window #1
    =========
    db2 "connect to sample"
    
       Database Connection Information
    
     Database server        = DB2/SUN64 8.2.9
     SQL authorization ID   = DB2INST1
     Local database alias   = SAMPLE
    
    $ db2 +c "lock table test1 in exclusive mode"
    DB20000I  The SQL command completed successfully.
    
    
    Window #2
    ===========
    $ db2 "connect to sample"
    
       Database Connection Information
    
     Database server        = DB2/SUN64 8.2.9
     SQL authorization ID   = DB2INST1
     Local database alias   = SAMPLE
    
    $ db2 "call sp_tst(?,?,?)"
    ^CSQL0952N  Processing was cancelled due to an interrupt.
    SQLSTATE=57014
    
    
    db2diag.log
    ============
    
    
    2008-09-03-19.33.30.553229-240 I969A1095          LEVEL: Error
    PID     : 26771                TID  : 1           PROC :
    db2agent (SAMPLE) 0
    INSTANCE: majason              NODE : 000         DB   : SAMPLE
    APPHDL  : 0-17                 APPID: G91A308D.A72D.080903233319
    MESSAGE : Severe TERMINATE err at nest lvl 1, in SQL from rtn
    SP_TST:
    DATA #1 : Hexdump, 136 bytes
    0x0000000102CF4468 : 5351 4C43 4120 2020 0000 0088 FFFF FC48
    SQLCA   .......H
    0x0000000102CF4478 : 0000 2020 2020 2020 2020 2020 2020 2020
    ..
    0x0000000102CF4488 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x0000000102CF4498 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x0000000102CF44A8 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x0000000102CF44B8 : 2020 2020 2020 2020 5351 4C52 5230 4132
    SQLRR0A2
    0x0000000102CF44C8 : 8010 0003 0000 0003 0000 0000 0000 0000
    ................
    0x0000000102CF44D8 : 0000 0000 0000 0000 2020 2020 2020 2020
    ........
    0x0000000102CF44E8 : 2020 2035 3730 3134
    57014
    
    2008-09-03-19.33.30.597747-240 I2065A807          LEVEL: Error
    PID     : 26771                TID  : 1           PROC :
    db2agent (SAMPLE) 0
    INSTANCE: db2inst1              NODE : 000         DB   :
    SAMPLE
    APPHDL  : 0-17                 APPID: G91A308D.A72D.080903233319
    MESSAGE : sqlrr_rds_common_pre1():
    DATA #1 : Hexdump, 85 bytes
    0xFFFFFFFF7FFEBE50 : 2D32 3031 3339 3A20 5072 696F 7220 6E65
    -20139: Prior ne
    0xFFFFFFFF7FFEBE60 : 7374 6564 2054 4552 4D49 4E41 5445 2065
    sted TERMINATE e
    0xFFFFFFFF7FFEBE70 : 7272 2E20 5271 7374 2061 7420 6E65 7374
    rr. Rqst at nest
    0xFFFFFFFF7FFEBE80 : 206C 766C 2031 2066 726F 6D20 7274 6E20
    lvl 1 from rtn
    0xFFFFFFFF7FFEBE90 : 5355 5245 4E2E 5350 5F54 5354 2069 676E
    SUREN.SP_TST ign
    0xFFFFFFFF7FFEBEA0 : 6F72 6564 2E
    ored.
    
    2008-09-03-19.33.30.600014-240 I2873A352          LEVEL: Severe
    PID     : 26771                TID  : 1           PROC :
    db2agent (SAMPLE) 0
    INSTANCE: db2inst1              NODE : 000         DB   : SAMPLE
    APPHDL  : 0-17                 APPID: G91A308D.A72D.080903233319
    FUNCTION: DB2 UDB, PSM - SQL Procedure, PVM::run, probe:671
    MESSAGE : Running PVM
    
    2008-09-03-19.33.30.603316-240 I3226A168          LEVEL: Severe
    PID:26771 TID:1 NODE:000 Title: PSM_PVMPROGRAM
    ...
    

Local fix

Problem summary

  • See ERROR DESCRIPTION.
    

Problem conclusion

  • Problem was first fixed in v9.1 FP7 (s090308).  At minimum this
    fix should be applied on the server side.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ31418

  • Reported component name

    DB2 UDB ESE SOL

  • Reported component ID

    5765F4102

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-09-08

  • Closed date

    2009-04-15

  • Last modified date

    2009-04-15

  • APAR is sysrouted FROM one or more of the following:

    IZ31417

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 UDB ESE SOL

  • Fixed component ID

    5765F4102

Applicable component levels

  • R810 PSN

       UP

  • R820 PSN

       UP

  • R910 PSN

       UP

  • R950 PSN

       UP

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910"}]

Document Information

Modified date:
04 October 2021