Db2 Message Audit Error. Sqlcode Is
Contents |
(troubleshooting) Problem(Abstract) db2diag.log contains various errors such as 'DIA8506C Unexpected end of file was reached' db2 sql error sqlcode 204 sqlstate 42704 or 'Unexpected System Error' or RETCODE such as 'ZRC=0x870F0009' 'ZRC=0x875C00CD' or
Db2 Sql Error Sqlcode 803
sqlcode: -1042 Symptom The following messages can be seen in db2diag.log when DB2 attempts to audit. 2013-11-08-00.08.39.394606-300 db2 sql error sqlcode 104 sqlstate 42601 I2075E629 LEVEL: Error PID : 27045 TID : 46913005021504 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : FOO APPHDL : 0-33 APPID: *LOCAL.db2inst1.131108050839 HOSTNAME: db2host EDUID http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.messages.sql.doc/doc/msql01322n.html : 18 EDUNAME: db2agent (FOO) FUNCTION: DB2 UDB, bsu security, sqlexAuditOpenAdjust, probe:149 RETCODE : ZRC=0x870F0009=-2029060087=SQLO_EOF "the data does not exist" DIA8506C Unexpected end of file was reached. DATA #1 : Hexdump, 4 bytes 0x00002AAAC8FFB380 : 0900 0F87 .... 2013-11-08-00.08.39.473542-300 I2705E554 LEVEL: Error PID : 27045 TID : 46913005021504 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 http://www.ibm.com/support/docview.wss?uid=swg21655610 DB : FOO APPHDL : 0-33 APPID: *LOCAL.db2inst1.131108050839 HOSTNAME: db2host EDUID : 18 EDUNAME: db2agent (FOO) FUNCTION: DB2 UDB, bsu security, sqlexAuditWriteBufferToDisk, probe:14164 MESSAGE : ZRC=0x875C00CD=-2024013619=SQLEX_UNEXPECTED_SYSERR "Unexpected System Error" DATA #1 : Hex integer, 4 bytes 0x40000011 ... 2013-11-08-00.08.39.474498-300 I4308E930 LEVEL: Error PID : 27045 TID : 46913005021504 PROC : db2sysc INSTANCE: db2inst1 NODE : 000 DB : FOO APPHDL : 0-33 APPID: *LOCAL.db2inst1.131108050839 HOSTNAME: db2host EDUID : 18 EDUNAME: db2agent (FOO) FUNCTION: DB2 UDB, bsu security, sqlexAuditData::logEvent, probe:1089 MESSAGE : ZRC=0x875C00CD=-2024013619=SQLEX_UNEXPECTED_SYSERR "Unexpected System Error" DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1042 sqlerrml: 3 sqlerrmc: 205 sqlerrp : SQLEXADT sqlerrd : (1) 0x875C00CD (2) 0x000000CD (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: Cause db2audit file for the database is either corrupt or has wrong file size. Resolving the problem Find the corresponding Audit Data Path by issuing 'db2audit describe' command. Then rename the audit
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle http://database.ittoolbox.com/groups/technical-functional/db2-l/in-db2diag-frequently-getting-this-error-4435310 PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database http://www.dbatodba.com/db2/problem-resolution/replication-problem/capture-error-reading-db2-log Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP MacProTX VoIP_News Inside-CRM PCMag I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Locutus Ramnath.Awate Richard db2 sql DukeGanote Craig Borysowich Dennis Stevenson Nikki Klein mircea_luca AbhaiTripathi knowscognosdoi Clinton Jones bluesguyAZ59 Iqbalyk blrvenkat COMPANIES Juniper Networks CloudLock Avaya Adaptive Planning View All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is for the discussion of technical db2 sql error issues related to the installation, configuration, or daily administration of IBM DB2 LUW databases. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. In db2diag Frequently Getting This Error k viswanath asked Sep 22, 2011 | Replies (1) Hi All, 2 ERROR : Please check and confirm what is the error help me out of this. 2011-09-22-21.00.11.119321+330 I153936571A485 LEVEL: Error PID : 12386400 TID : 1 PROC : db2agent (MINE) 0 INSTANCE: db2a
reading DB2 log Navigation Home DB2 DB2 Mainframe Informix Mysql Oracle PostgreSQL SQL Server Sybase Forums Log in Login Name Password Cookies are not enabled. You must enable cookies before you can log in. Forgot your password? Document Actions Capture: Error reading DB2 log The DB2 transaction log changes needed by capture process can’t be read 1.1 Error message ASN0005E The Capture program encountered an error while reading the DB2 log.The log sequence number is