Error in DB rollback/SyFlush, return code 000256

[former_member289569]

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

[Former Member]

Hi

      Do yo find the solution??

Regards

[former_member289569]

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

[sunny_pahuja2]

Hi,

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

Thanks

Sunny