Skip to Content
avatar image
Former Member

Error in DB rollback/SyFlush, return code 000256

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 15, 2011 at 01:05 PM

    Hi,

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

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 24, 2011 at 08:50 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 10, 2013 at 06:22 PM

    Hi

          Do yo find the solution??

    Regards

    Add comment
    10|10000 characters needed characters exceeded