3 Replies Latest reply: Apr 10, 2013 8:22 PM by Jesús Colmenarez RSS

Error in DB rollback/SyFlush, return code  000256

Juan Eloy Gomez
Currently Being Moderated

Hi friends

I have a problem with new instalaction over windows 2008 R2 and database DB6, the system sometimes is hang with error " Error in DB rollback/SyFlush, return code  000256", when check me the service of DB2 is down.

 

Thanks in advance.

Jose

  • Re: Error in DB rollback/SyFlush, return code  000256
    Sunny Pahuja
    Currently Being Moderated

    Hi,

     

    Could you please check window event logs and also paste db2diag.log here ?

     

    Thanks

    Sunny

  • Re: Error in DB rollback/SyFlush, return code  000256
    Juan Eloy Gomez
    Currently Being Moderated

    Hi, it is db2diag.log, this error down service of DB2.

     

    2011-11-24-15.00.06.217000-270 I6859178F336       LEVEL: Event

    PID     : 7384                 TID  : 7056        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 7056                 EDUNAME: db2pdbe 0

    FUNCTION: DB2 UDB, RAS/PD component, pdDumpTempTableStats, probe:3531

    START   : db2pd -temptable started

     

    2011-11-24-15.00.06.233000-270 I6859516F337       LEVEL: Event

    PID     : 7384                 TID  : 7056        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 7056                 EDUNAME: db2pdbe 0

    FUNCTION: DB2 UDB, RAS/PD component, pdDumpTempTableStats, probe:3661

    START   : db2pd -temptable finished

     

    2011-11-24-15.02.02.282000-270 E6859855F563       LEVEL: Error

    PID     : 7280                 TID  : 1704        PROC : db2fmp64.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 1704

    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::executeTask, probe:600

    MESSAGE : ZRC=0xFFFFFB38=-1224

    DATA #1 : <preformatted>

    [IBM][CLI Driver] SQL1224N  The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request because of an error or a forced interrupt.  SQLSTATE=55032

     

     

    2011-11-24-15.02.02.313000-270 E6860420F414       LEVEL: Error

    PID     : 7280                 TID  : 1704        PROC : db2fmp64.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 1704

    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsConnection::setApplName, probe:100

    MESSAGE : ZRC=0xFFFE7961=-99999

    DATA #1 : <preformatted>

    [IBM][CLI Driver] CLI0108E  Communication link failure. SQLSTATE=40003

     

    2011-11-24-15.02.02.313000-270 E6860836F412       LEVEL: Error

    PID     : 7280                 TID  : 1704        PROC : db2fmp64.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 1704

    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsConnection::rollback, probe:900

    MESSAGE : ECF=0x82BA00E2=-2101739294

    DATA #1 : String, 64 bytes

    [IBM][CLI Driver] CLI0106E  Connection is closed. SQLSTATE=08003

     

    2011-11-24-15.02.02.313000-270 I6861250F340       LEVEL: Error

    PID     : 7280                 TID  : 1704        PROC : db2fmp64.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 1704

    FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::run, probe:1200

    MESSAGE : ECF=0x82BA00E4=-2101739292

    DATA #1 : Codepath, 8 bytes

    4

     

    2011-11-24-15.05.10.669000-270 E6861592F888       LEVEL: Warning

    PID     : 7148                 TID  : 7624        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 7624

    FUNCTION: DB2 UDB, license manager, sqllcRequestAccess, probe:1

    MESSAGE : ADM12007E  There are "13" day(s) left in the evaluation period for

              the product "DB2 Enterprise Server Edition". For evaluation license

              terms and conditions, refer to the IBM License Acceptance and License

              Information document located in the license directory in the

              installation path of this product. If you have licensed this product,

              ensure the license key is properly registered. You can register the

              license via the License Center or db2licm command line utility. The

              license file can be obtained from your licensed product CD.

     

    2011-11-24-15.05.10.700000-270 I6862482F857       LEVEL: Warning

    PID     : 7148                 TID  : 7624        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 7624

    FUNCTION: DB2 UDB, license manager, sqllcRequestAccess, probe:1

    MESSAGE : SQL8007W  There are "13" day(s) left in the evaluation period for the

              product "DB2 Enterprise Server Edition". For evaluation license terms

              and conditions, refer to the License Agreement document located in

              the license directory in the installation path of this product. If

              you have licensed this product, ensure the license key is properly

              registered. You can register the license via the License Center or

              db2licm command line utility. The license key can be obtained from

              your licensed product CD.

     

    2011-11-24-15.05.11.246000-270 I6863341F544       LEVEL: Event

    PID     : 7148                 TID  : 1920        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 1920                 EDUNAME: db2sysc 0

    FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10

    START   : Starting FCM Buffer Manager

    1 resource group(s).

    128 buffers allocated.

    Maximum number of buffers supported is 8192.

    Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 925712 bytes.

     

    2011-11-24-15.05.11.262000-270 I6863887F551       LEVEL: Event

    PID     : 7148                 TID  : 1920        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 1920                 EDUNAME: db2sysc 0

    FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10

    START   : Starting FCM Channel Manager

    1 resource group(s).

    128 channels allocated.

    Maximum number of channels supported is 8192.

    Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 507928 bytes.

     

    2011-11-24-15.05.11.262000-270 I6864440F550       LEVEL: Event

    PID     : 7148                 TID  : 1920        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 1920                 EDUNAME: db2sysc 0

    FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10

    START   : Starting FCM Session Manager

    1 resource group(s).

    128 sessions allocated.

    Maximum number of sessions supported is 64000.

    Total session manager memory required for 1 logical and 0 fail-over partitions is 1683456 bytes.

     

    2011-11-24-15.05.11.262000-270 I6864992F428       LEVEL: Event

    PID     : 7148                 TID  : 1920        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 1920                 EDUNAME: db2sysc 0

    FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500

    START   : FCM infrastructure started

    FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IPv4

     

    2011-11-24-15.05.11.355000-270 E6865422F450       LEVEL: Warning

    PID     : 7148                 TID  : 1920        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 1920                 EDUNAME: db2sysc 0

    FUNCTION: DB2 UDB, routine_infrastructure, sqlerInitFmpTable, probe:30

    DATA #1 : String, 16 bytes

    agentCachingFmp:

    DATA #2 : String, 3 bytes

    OFF

    DATA #3 : String, 5 bytes

    Flag:

    DATA #4 : Boolean, 1 bytes

    false

     

    2011-11-24-15.05.12.447000-270 E6865874F328       LEVEL: Event

    PID     : 7148                 TID  : 7624        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 7624

    FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911

    MESSAGE : ADM7513W  Database manager has started.

    START   : DB2 DBM

     

    2011-11-24-15.05.23.632000-270 I6866204F327       LEVEL: Event

    PID     : 6324                 TID  : 7032        PROC : db2start.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 7032

    FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:21

    DATA #1 : <preformatted>

    Single node instance [0] is starting

     

    2011-11-24-15.05.23.664000-270 I6866533F1686      LEVEL: Event

    PID     : 6324                 TID  : 7032        PROC : db2start.exe

    INSTANCE: DB2CAL               NODE : 000

    EDUID   : 7032

    FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130

    DATA #1 : String, 44 bytes

    D:\db2\db2cal\db2_software
    bin\DB2STAR2.EXE

    DATA #2 : Hexdump, 256 bytes

    0x00000000001271E0 : 443A 5C64 6232 5C64 6232 6361 6C5C 6462    D:\db2\db2cal\db

    0x00000000001271F0 : 325F 736F 6674 7761 7265 5C5C 6269 6E5C    2_software
    bin\

    0x0000000000127200 : 4442 3253 5441 5232 2E45 5845 004E 4F4D    DB2STAR2.EXE.NOM

    0x0000000000127210 : 5347 0000 0000 0000 0000 0000 0000 0000    SG..............

    0x0000000000127220 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x0000000000127230 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x0000000000127240 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x0000000000127250 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x0000000000127260 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x0000000000127270 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x0000000000127280 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x0000000000127290 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x00000000001272A0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x00000000001272B0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x00000000001272C0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

    0x00000000001272D0 : 0000 0000 0000 0000 0000 0000 0000 0000    ................

     

    2011-11-24-15.05.25.052000-270 E6868221F480       LEVEL: Event

    PID     : 7148                 TID  : 1396        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000         DB   : CAL

    APPHDL  : 0-7                  APPID: *LOCAL.DB2CAL.111124193525

    AUTHID  : SAPSERVICECAL

    EDUID   : 1396                 EDUNAME: db2agent (CAL) 0

    FUNCTION: DB2 UDB, Self tuning memory manager, stmmLog, probe:1008

    DATA #1 : <preformatted>

    Starting STMM log from file number 30

     

    2011-11-24-15.05.25.177000-270 I6868703F516       LEVEL: Event

    PID     : 7148                 TID  : 1396        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000         DB   : CAL

    APPHDL  : 0-7                  APPID: *LOCAL.DB2CAL.111124193525

    AUTHID  : SAPSERVICECAL

    EDUID   : 1396                 EDUNAME: db2agent (CAL) 0

    FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20

    CHANGE  : CFG DB CAL     : "Database_memory" From: "1120660" <automatic>  To: "1056608" <automatic>

     

    2011-11-24-15.05.25.489000-270 I6869221F445       LEVEL: Warning

    PID     : 7148                 TID  : 1396        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000         DB   : CAL

    APPHDL  : 0-7                  APPID: *LOCAL.DB2CAL.111124193525

    AUTHID  : SAPSERVICECAL

    EDUID   : 1396                 EDUNAME: db2agent (CAL) 0

    FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30

    MESSAGE : Crash Recovery is needed.

     

    2011-11-24-15.05.27.969000-270 I6869668F453       LEVEL: Warning

    PID     : 7148                 TID  : 1396        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000         DB   : CAL

    APPHDL  : 0-7                  APPID: *LOCAL.DB2CAL.111124193525

    AUTHID  : SAPSERVICECAL

    EDUID   : 1396                 EDUNAME: db2agent (CAL) 0

    FUNCTION: DB2 UDB, relation data serv, sqlrr_db_init, probe:700

    MESSAGE : DB2_IMPLICIT_UNICODE enabled

     

    2011-11-24-15.05.27.969000-270 E6870123F476       LEVEL: Event

    PID     : 7148                 TID  : 1396        PROC : db2syscs.exe

    INSTANCE: DB2CAL               NODE : 000         DB   : CAL

    APPHDL  : 0-7                  APPID: *LOCAL.DB2CAL.111124193525

    AUTHID  : SAPSERVICECAL

    EDUID   : 1396                 EDUNAME: db2agent (CAL) 0

    FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:1000

    START   : DATABASE: CAL      : ACTIVATED: YES

     

     

     

       

     

    thanks in advance

    JOse

  • Re: Error in DB rollback/SyFlush, return code  000256
    Jesús Colmenarez
    Currently Being Moderated

    Hi

     

          Do yo find the solution??

     

    Regards

Actions