DIA3819C A file sharing violation has occurred, filename was ""

[varlagas]

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 ˜ϋ�.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 ˜ϋ�.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 Ï„ÂŽ..8ÎŒÎ*..........

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
....

[Anton Versteeg via DBMonster.com]

va******@yahoo.com wrote:

We disabled the antivirus software but the problem persists. Any clues?

Many thanks in advance!

Panagiotis Varlagas

Perhaps a backup program?
--
Message posted via http://www.dbmonster.com

[varlagas]

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.

Anton Versteeg via DBMonster.com wrote:

va******@yahoo.com wrote:

We disabled the antivirus software but the problem persists. Any clues?

Many thanks in advance!

Panagiotis Varlagas

Perhaps a backup program?
--
Message posted via http://www.dbmonster.com

[varlagas]

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...

[Dave Hughes]

Anton Versteeg via DBMonster.com wrote:

va******@yahoo.com wrote:

We disabled the antivirus software but the problem persists. Any
clues?

Many thanks in advance!

Panagiotis Varlagas

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.
--
Dave Hughes, da*********@waveform.plus.com
(remove _nospam for correct address)
"Cogito cogito ergo cogito sum" - Ambrose Bierce

[varlagas]

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.

Dave Hughes wrote:

Anton Versteeg via DBMonster.com wrote:

va******@yahoo.com wrote:

We disabled the antivirus software but the problem persists. Any
clues?

Many thanks in advance!

Panagiotis Varlagas

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.
--
Dave Hughes, da*********@waveform.plus.com
(remove _nospam for correct address)
"Cogito cogito ergo cogito sum" - Ambrose Bierce

[db2newbie]

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.