 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / July 2005DIA3819C A file sharing violation has occurred, filename was ""
We disabled the antivirus software but the problem persists. Any clues? Many thanks in advance! Panagiotis Varlagas =====================================================================2005-07-28-10.39.02.015001 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 buffer_pool_services sqlbSMSOpenContainer Probe:820 Database:NOVA DIA3819C A file sharing violation has occurred, filename was "". ZRC=0xFFFFF616 2005-07-28-10.39.02.187000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 buffer_pool_services sqlbSMSOpenContainer Probe:820 Database:NOVA Obj={pool:2;obj:15;type:0} State=x0 Cont=0 D:\DB2\Sqlt0002.0\SQL00015.DAT Data Title:SQLB_OBJECT_DESC PID:1568 TID:2440 Node:000 0200 0f00 0200 0f00 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0101 0000 0000 0000 0000 0000 ................ 0010 0000 2000 0000 0100 0000 0200 0f00 .... ........... 98fb bf18 3000 c418 =8F.0.. 2005-07-28-10.39.02.515000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 buffer_pool_services sqlbSMSGetOpenInfo Probe:810 Database:NOVA DIA3819C A file sharing violation has occurred, filename was "". ZRC=0xFFFFF616 2005-07-28-10.39.02.624000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 buffer_pool_services sqlbSMSGetOpenInfo Probe:810 Database:NOVA Obj={pool:2;obj:15;type:0} State=x0 Cont=0 Data Title:SQLB_OBJECT_DESC PID:1568 TID:2440 Node:000 0200 0f00 0200 0f00 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0101 0000 0000 0000 0000 0000 ................ 0010 0000 2000 0000 0100 0000 0200 0f00 .... ........... 98fb bf18 3000 c418 =8F.0.. 2005-07-28-10.39.02.843000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 buffer_pool_services sqlbReadPage Probe:1130 Database:NOVA DIA3819C A file sharing violation has occurred, filename was "". ZRC=0xFFFFF616 2005-07-28-10.39.02.921000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 data_management loadSMSDesc Probe:1171 Database:NOVA DIA3819C A file sharing violation has occurred, filename was "". ZRC=0xFFFFF616 2005-07-28-10.39.03.030000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 data_management loadSMSDesc Probe:1268 Database:NOVA DIA3819C A file sharing violation has occurred, filename was "". ZRC=0xFFFFF616 2005-07-28-10.39.03.108000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 data_management sqldLoadTCB Probe:7 Database:NOVA DIA3819C A file sharing violation has occurred, filename was "". ZRC=0xFFFFF616 Dump File:D:\SQLLIB\DB2\15682440.000 Data:SQLD_TCB 2005-07-28-10.39.03.233000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 data_management sqldFixTCB Probe:2704 Database:NOVA DIA3819C A file sharing violation has occurred, filename was "". ZRC=0xFFFFF616 2005-07-28-10.39.03.327000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 data_management sqldGetTableData Probe:157 Database:NOVA DIA3819C A file sharing violation has occurred, filename was "". ZRC=0xFFFFF616 2005-07-28-10.39.03.421000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 data_management sqldGetTableData Probe:157 Database:NOVA Error getting page count for table - lockInfo is: 0200 0f00 0000 0000 0000 0000 5400 0000 ............T... f48e 0516 38bc d001 0000 0000 0000 0000 =8E..8=A0......... 0000 0000 0600 0000 0100 0000 0000 0000 ................ 0000 0000 0000 0040 .......@ 2005-07-28-10.39.03.593000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 global_services sqlzerdm Probe:40 Database:NOVA 16f6 ffff . Data Title:SQLCA PID:1568 TID:2440 Node:000 sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 2 sqlerrmc: 22 sqlerrp : SQLNQ045 sqlerrd : (1) 0xFFFFF616 (2) 0x00000016 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFFFDD (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: 00000 Dump File:D:\SQLLIB\DB2\15682440.000 Data:SQLCA 2005-07-28-10.39.03.718000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 relation_data_serv sqlrrdi Probe:120 Database:NOVA 16f6 ffff . Data Title:rc_flags: PID:1568 TID:2440 Node:000 4000 0004 @... 2005-07-28-10.39.03.812000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 base_sys_utilities sqleflsr Probe:1 Database:NOVA DiagData 4001 0004 @... 2005-07-28-10.39.03.890000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 base_sys_utilities sqleflsr Probe:1 Database:NOVA RIDS/sqleflsr MS/DB_BAD_FAT PRCS/14001 0004 @... 2005-07-28-10.39.03.952000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 base_sys_utilities sqleflsr Probe:2 Database:NOVA DiagData 5351 4c43 4120 2020 8800 0000 7afc ffff SQLCA ...z 0200 3232 0000 0000 0000 0000 0000 0000 ..22............ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 5351 4c4e 5130 3435 ........SQLNQ045 16f6 ffff 1600 0000 0000 0000 0000 0000 ............. ddff ffff 0000 0000 2020 2020 2020 2020 .... 2020 2030 3030 3030 00000 2005-07-28-10.39.04.124000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 base_sys_utilities sqleflsr Probe:2 Database:NOVA RIDS/sqleflsr MS/DB_BAD_FAT PRCS/25351 4c43 4120 2020 8800 0000 7afc ffff SQLCA ...z 0200 3232 0000 0000 0000 0000 0000 0000 ..22............ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 5351 4c4e 5130 3435 ........SQLNQ045 16f6 ffff 1600 0000 0000 0000 0000 0000 ............. ddff ffff 0000 0000 2020 2020 2020 2020 .... 2020 2030 3030 3030 00000 String Title:sqleMarkDBad: PID:1568 Node:000 Marking the database bad. 2005-07-28-10.39.04.327000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 base_sys_utilities sqlesrsp Probe:9 Database:NOVA DiagData f6fb ffff 2005-07-28-10.39.04.437000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 base_sys_utilities sqlesrsp Probe:9 Database:NOVA RIDS/sqlesrsp MS/DB_BAD_FAT PRCS/9f6fb ffff 2005-07-28-10.39.04.546000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2040 Appid:0A00153A.B80B.050728083206 base_sys_utilities sqlesrsp Probe:9 Database:NOVA DiagData f6fb ffff 2005-07-28-10.39.04.640000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2040 Appid:0A00153A.B80B.050728083206 base_sys_utilities sqlesrsp Probe:9 Database:NOVA RIDS/sqlesrsp MS/DB_BAD_FAT PRCS/9f6fb ffff 2005-07-28-10.39.05.077000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:592 Appid:0A00153A.C80B.050728083632 base_sys_utilities sqlesrsp Probe:9 Database:NOVA DiagData f6fb ffff 2005-07-28-10.39.05.155000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:592 Appid:0A00153A.C80B.050728083632 base_sys_utilities sqlesrsp Probe:9 Database:NOVA RIDS/sqlesrsp MS/DB_BAD_FAT PRCS/9f6fb ffff 2005-07-28-10.39.05.608000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 base_sys_utilities sqledbcu Probe:31 Database:NOVA Database bad recovery recovery processing initiated0000 0000 .... 2005-07-28-10.39.05.671000 Instance:DB2 Node:000 PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720 base_sys_utilities sqledbcu Probe:33 Database:NOVA Number of local applications forced: 0200 0000 .... >We disabled the antivirus software but the problem persists. Any clues? > >Many thanks in advance! > >Panagiotis Varlagas Perhaps a backup program? Could be. But, how do we investigate this? How can I understand which file is being used by another program and which this other program is? Unfortunately, we are using an unsupported version of DB2 (7.1.7, service level WR21306) so IBM won't provide formal help. So, I would especially appreciate the informal help of you guys! For instance, people talk about using filemon to investigate the problem. But where should I focus my attention in filemon's output? Many thanks! Panagiotis. > >We disabled the antivirus software but the problem persists. Any clues? > > [quoted text clipped - 3 lines] > > > Perhaps a backup program? Is it possible that this issue goes away with applying the highest available fix pack for V7 (Fixpack 14)? Is anybody cognizant of an APAR that solves this issue? I've looked into the list of APARs, but none of the APARs mentioned in there seems directly related to this issue. Any help would be greatly appreciated... > > We disabled the antivirus software but the problem persists. Any > > clues? [quoted text clipped - 4 lines] > > > Perhaps a backup program? Another possibility (I ran into something similar with an installer recently) is Google Desktop Search (if you're using it). HTH, Dave.  SignatureDave Hughes, dave_nospam@waveform.plus.com (remove _nospam for correct address) "Cogito cogito ergo cogito sum" - Ambrose Bierce Actually, Google Desktop Search is not running on the machine of interest. But actually (to return to an earlier reply) Veritas Backup Exec is installed on that machine. However, it has been there for some time, and the problem only appeared yesterday. > > > We disabled the antivirus software but the problem persists. Any > > > clues? [quoted text clipped - 13 lines] > (remove _nospam for correct address) > "Cogito cogito ergo cogito sum" - Ambrose Bierce Quick solution: 1) check whether there is any problem with D:\DB2\Sqlt0002.0\SQL00015.DAT. I am suspecting that other process is locking this file or this file has been corrupted somehow. You can use handle.exe from http://www.sysinternals.com/utilities/handle.html. 2) If you know how to convert the ZRC=0xFFFFF616 to something more meaningful, you can isolate the problem further. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.