Db2 Error Creating A Counting Semaphore
recovery Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 3 ] 1 Topic by chuk_and_gek 2012-06-14 06:57:10 chuk_and_gek Member Offline Registered: 2012-05-03 Posts: 174 Topic: Problem with DB recovery Good afternoon!We have:OSName: SunOSNodeName: trinidadVersion: Generic_118558-39Release: 5.9Machine: sun4uDB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09058"with level identifier "06090107".Informational tokens are "DB2 v9.5.0.8", "s110603", "IP23267", and Fix Pack"8".Product is installed at "/opt/IBM/db2/V9.5".We fulfill:db2 RESTORE DATABASE asukp user.... using.... FROM/common/backup/db2 TAKEN AT 20111205152132 TO/common/database/db2/asukp INTO asukp NEWLOGPATH/common/database/db2/asukp/logs WITH 2 BUFFERS BUFFER 1024 PARALLELISM 1 WITHOUT PROMPTINGWe receive:SQL0902C A system error (reason code = "") occurred. Subsequent SQLstatements cannot be processed. SQLSTATE=58005Here an exposure from :2011-12-06-10.28.26.595010+240 I42158A674 LEVEL: WarningPID: 22122 TID: 1 PROC: db2bpINSTANCE: db2inst1 NODE: 000EDUID: 1FUNCTION: DB2 UDB, Connection Manager, sqleUCgetDirInfo, probe:1012DATA #1: SQLCA, PD_DB2_TYPE_SQLCA, 136 bytessqlcaid: SQLCA sqlcabc: 136 sqlcode:-1013 sqlerrml: 5sqlerrmc: ASUKPsqlerrp: SQLEUCCMsqlerrd: (1) 0x00000000 (2) 0x00000000 (3) 0x00000000(4) 0x00000000 (5) 0x00000000 (6) 0x00000000sqlwarn: (1 (2) (3) (4) (5) (6)(7 (8) (9) (10) (11)sqlstate:2011-12-06-10.28.26.854247+240 I42833A461 LEVEL: EventPID: 7413 TID: 15 PROC: db2sysc 0INSTANCE: db2inst1 NODE: 000APPHDL: 0-410 APPID: *LOCAL.db2inst1.111206055533AUTHID: DB2INST1EDUID: 15 EDUNAME: db2agent (instance) 0FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:20CHANGE: CFG DB ASUKP: "Num_ioservers" From: "3"
(troubleshooting) Problem(Abstract) DB2 10.5 APAR Fix list contains list of APARs shipped for each fix pack in DB2 Version 10.5 for Linux, UNIX and Windows products. The Severity column value of 1 is high and 4 is low. Severity column represents the severity of the PMR at the time the APAR was opened. Resolving the problem Tab navigation DB2 10.5 DB2 10.1 DB2 9.8 DB2 9.7 DB2 9.5 - selected tab, DB2 9.1 DB2 8 Tab navigation Download DB2 10.5 fix http://www.progtown.com/topic676109-problem-with-db-recovery.html packs Download clients and drivers DB2 10.5 Fix Pack Installation Methods DB2 Product Documentation ************************************************************ Product Name : DB2 UDB Version 10.5 Updated : Tue Sep 6 13:07:04 EDT 2016 ************************************************************ Select a Fix Pack: 8 | 7 | 6 | 5 | 4 | 3a | 3 | 2 | 1 DB2 Version 10.5 Fix Pack 8 APAR Sev. Abstract Fix http://www-01.ibm.com/support/docview.wss?uid=swg21633303 Pack 8 - 1 IT12747 2 INSTANCE MAY TRAP IN XMLRNSEQUENCE::ADDITEMSUBTREE FUNCTION Fix Pack 8 - Administration Tools IT13952 2 INCORRECT ORDER OF INDEXES GENERATED DURING DB2LOOK PROCESSING IT11297 2 DB2LOOK DOES NOT PRODUCE FEDERATION SERVER OBJECTS WHEN SERVER NAME IS CREATED IN MIXED CASE IT13061 2 DB2LOOK RETURNS ERROR SQL0206N FOR SQL0206N IT14381 2 AUTOMATIC REORG MIGHT OMIT MDC TABLE IT14574 3 DB2LOOK -T -XDEP DOES NOT GENERATE GRANT USE OF TABLESPACE STATEMENTS Fix Pack 8 - Buffer Pool Services IT13690 1 AFTER MEMBER CRASH RECOVERY ON PURESCALE, THE DATABASE MANAGER IS NOT ABLE TO ACCEPT NEW REQUESTS. IT15748 1 REVERT TO PREVIOUS METHOD OF CALCULATING ASYNCHRONOUS WRITE TIME FOR DB2 MONITORING IT14877 2 REDIRECT RESTORE FAILS WITH "DBPATH ON" OPTION IT15879 2 DB2 MIGHT CRASH FOR AN ALTER STORAGE GROUP IT12804 2 HANG DEADLATCH SQLO_LT_SQLB_BUFFERPOOL__PREVBPDCACHINGLATCH / SQLO_LT_SQLB_BPD__BPDLATCH_SX IT14562 2 SNAPSHOT BACKUP HANGS WHEN THERE IS EXTENT MOVEMENT IN PROGRESS (E.G. ALTER TABLESPACE REDUCE) IT11608 2 TABLESPACE SIZE CAN EXCEED ITS MAXSIZE AFTER REBALANCE Fix Pack 8 - Build Team IT11592 2 TRUNCATE AN EMPTY TABLE, LOAD ARE TAKING
2.4.19-64GB-SMP #1 SMP Thu Mar 20 14:41:55 http://www.yqcomputer.com/1257_5076_1.htm UTC 2003 i686 unknown Installed is DB2 Workgroup Edition 7.2: DB21085I Instance "db2inst" uses DB2 code release "SQL07029" with level identifier "030A0105" and informational tokens "DB2 v7.1.0.98", "s040510" and "U497046". The message says: Error creating a counting semaphore What does this mean? Thanks in advance. This is db2 error what we found in the DB2DIAG.LOG: 2004-12-06-12.36.46.706463 Instance:db2inst Node:000 PID:30801(db2agent (DBX)) Appid:C1609C10.79C0.041206080705 oper_system_services sqloCSemCreate Probe:1 Database:DBX 1c00 0000 .... 2004-12-06-12.36.46.790251 Instance:db2inst Node:000 PID:30801(db2agent (DBX)) Appid:C1609C10.79C0.041206080705 buffer_pool_services sqlbpfCreateQ Probe:5 Database:DBX Error creating a counting semaphore 2004-12-06-12.36.46.886657 Instance:db2inst Node:000 PID:30801(db2agent (DBX)) Appid:C1609C10.79C0.041206080705 buffer_pool_services sqlbpfCreateQ Probe:4 Database:DBX DiagData 77f6 db2 error creating ffff w 2004-12-06-12.36.47.000773 Instance:db2inst Node:000 PID:30801(db2agent (DBX)) Appid:C1609C10.79C0.041206080705 buffer_pool_services sqlbPFStartPrefetchers Probe:7 Database:DBX DiagData 77f6 ffff w 2004-12-06-12.36.47.074899 Instance:db2inst Node:000 PID:30801(db2agent (DBX)) Appid:C1609C10.79C0.041206080705 buffer_pool_services sqlbinit Probe:540 Database:DBX DIA9999E An internal error occurred. Report the following error code : "0xFFFFF677". 2004-12-06-12.36.47.105626 Instance:db2inst Node:000 PID:30801(db2agent (DBX)) Appid:C1609C10.79C0.041206080705 oper_system_services sqloCSemRemove Probe:1 Database:DBX 1600 0000 .... 2004-12-06-12.36.47.166378 Instance:db2inst Node:000 PID:30801(db2agent (DBX)) Appid:C1609C10.79C0.041206080705 oper_system_services sqloCSemRemove Probe:1 Database:DBX 1600 0000 .... 2004-12-06-12.36.47.174449 Instance:db2inst Node:000 PID:30801(db2agent (DBX)) Appid:C1609C10.79C0.041206080705 oper_system_services sqloCSemRemove Probe:1 Database:DBX 1600 0000 .... Top 1. Serious "Unspecific Error" in Web App 2. Mappi Failure "Unspecific Error" Is outlook set as your default email client? Do you have any other mapi clients installed- such as Eudora? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Othe