Discussion:
SQL0970N The system attempted to write to a read-only file. SQLSTATE=55009
(too old to reply)
z***@gmail.com
2007-09-14 06:27:45 UTC
Permalink
cannot create new database:(
need help,thank you.


db2diag.log

2007-09-14-13.45.16.606983+480 I1G1372 LEVEL: Event
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09010"
with level identifier "02010107".
Informational tokens are "DB2 v9.1.0.0", "s060629", "LINUXIA32", Fix Pack "0".
DATA #2 : System Info, 436 bytes
System: Linux localhost.localdomain 6 2 i686
CPU: total:1 online:1 Cores per socket:1 Threading degree per core:1
Physical Memory(MB): total:1011 free:53
Virtual Memory(MB): total:3012 free:2050
Swap Memory(MB): total:2001 free:1997
Kernel Params: msgMaxMessageSize:8192 msgMsgMap:16384 msgMaxQueueIDs:1024
msgNumberOfHeaders:16384 msgMaxQueueSize:16384
msgMaxSegmentSize:16 shmMax:268435456 shmMin:1 shmIDs:4096
shmSegments:4096 semMap:32000 semIDs:1024 semNum:32000
semUndo:32000 semNumPerID:250 semOps:32 semUndoSize:20
semMaxVal:32767 semAdjustOnExit:32767
Information in this record is only valid at the time when this file was
created (see this record's time stamp)

2007-09-14-13.45.16.606779+480 E1374G612 LEVEL: Warning (OS)
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:100
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
CALLED : OS, -, unspecified_system_function OSERR: EACCES (13)
DATA #1 : File name, 15 bytes
/tmp/SQLDIR.LK0

2007-09-14-13.45.16.609040+480 I1987G449 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:10
MESSAGE : directory:
DATA #1 : Hexdump, 15 bytes
0xBFE96D84 : 2F74 6D70 2F53 514C 4449 522E 4C4B 30 /tmp/SQLDIR.LK0

2007-09-14-13.45.16.609198+480 I2437G439 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:20
MESSAGE : permissions:
DATA #1 : Hexdump, 4 bytes
0xBFE96C68 : FF01 0000 ....

2007-09-14-13.45.16.609314+480 I2877G495 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:905
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2007-09-14-13.45.16.609504+480 I3373G391 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:905
DATA #1 : String, 29 bytes
Cannot create /tmp/SQLDIR.LK0

2007-09-14-13.45.16.609643+480 I3765G503 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbCreateAndLockParent, probe:910
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2007-09-14-13.45.16.609878+480 I4269G506 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:805
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2007-09-14-13.45.16.610078+480 I4776G493 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSAddContainerRequest, probe:805
DATA #1 : String, 119 bytes
Error acquiring container 0 (/home/db2inst1/db2inst1/NODE0000/HUNAN33/T0000000/C0000000.CAT) for tbsp 0. Rc = 840F0001

2007-09-14-13.45.16.610237+480 I5270G631 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbASSetPoolContsForDMS, probe:70
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
DATA #1 : String, 11 bytes
SYSCATSPACE
DATA #2 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
0
DATA #3 : unsigned integer, 4 bytes
1

2007-09-14-13.45.16.610537+480 E5902G612 LEVEL: Warning (OS)
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:100
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
CALLED : OS, -, unspecified_system_function OSERR: EACCES (13)
DATA #1 : File name, 15 bytes
/tmp/SQLDIR.LK0

2007-09-14-13.45.16.610792+480 I6515G449 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:10
MESSAGE : directory:
DATA #1 : Hexdump, 15 bytes
0xBFE96F5C : 2F74 6D70 2F53 514C 4449 522E 4C4B 30 /tmp/SQLDIR.LK0

2007-09-14-13.45.16.610918+480 I6965G439 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, oper system services, sqlomkdirp, probe:20
MESSAGE : permissions:
DATA #1 : Hexdump, 4 bytes
0xBFE96E40 : FF01 0000 ....

2007-09-14-13.45.16.611031+480 I7405G495 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:905
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2007-09-14-13.45.16.611215+480 I7901G391 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbLockAllDirs, probe:905
DATA #1 : String, 29 bytes
Cannot create /tmp/SQLDIR.LK0

2007-09-14-13.45.16.611367+480 I8293G497 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbLockParentDir, probe:910
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2007-09-14-13.45.16.611557+480 I8791G443 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:805
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"

2007-09-14-13.45.16.611694+480 I9235G487 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:805
DATA #1 : String, 119 bytes
Error releasing container 0 (/home/db2inst1/db2inst1/NODE0000/HUNAN33/T0000000/C0000000.CAT) for tbsp 0. Rc = 840F0001

2007-09-14-13.45.16.611848+480 I9723G10078 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSFreePoolContainers, probe:210
MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE
"Container not accessible"
DATA #1 : signed integer, 4 bytes
0
DATA #2 : signed integer, 4 bytes
0
DATA #3 : unsigned integer, 4 bytes
182
DATA #4 : Pool control block, PD_TYPE_SQLB_POOL_CB, 1556 bytes
name: SYSCATSPACE
poolID: 0
flags: 3102
flags2: 1400
tflags: 0
runtimeBufferPoolID: 1
ondiskBufferPoolID: 1
otblLastConsecPage: 3
extent_size: 4
prefetch_size: 0
page_size: 4096
truncThreshold: 0
readLatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 32768 (No X Starvation)
numXPostsPending = 0
firstXWaiter = 0x00000000
firstSWaiter = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
identity = SLATCH_DEFAULT::critical_section (23)
}

}
writeLatch:
{
state = 0x00010000
= {
held X: 1
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 32768 (No X Starvation)
numXPostsPending = 0
firstXWaiter = 0x00000000
firstSWaiter = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
identity = SLATCH_DEFAULT::critical_section (23)
}

}
sysTempInUseLatch:
{
state = 0x00000000
= {
held X: 0
reserved for X: 0
shared holders: 0
shared waiter: 0
exclusive waiter: 0
}
flags = 0 (X Starvation)
numXPostsPending = 0
firstXWaiter = 0x00000000
firstSWaiter = 0x00000000
cs = {
lock = { 0x00 [ unlocked ] }
identity = SLATCH_DEFAULT::critical_section (23)
}

}
reorgPoolID: 0
reorgObjID: 0
tokenMap: 0x00000000
spillMap: 0x00000000
StateChangeObjectID: 0
StateChangePoolID: 0
version: 2
pool_state: 1073741824
quiesce_count: 0
state_id:
0x1389884C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389885C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389886C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389887C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389888C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389889C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138988AC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138988BC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138988CC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138988DC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138988EC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138988FC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389890C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389891C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389892C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389893C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389894C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389895C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389896C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389897C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389898C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x1389899C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138989AC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138989BC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138989CC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138989DC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138989EC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x138989FC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A0C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A1C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A2C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A3C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A4C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A5C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A6C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A7C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A8C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898A9C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898AAC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898ABC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898ACC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898ADC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898AEC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898AFC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898B0C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898B1C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898B2C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898B3C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898B4C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898B5C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898B6C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898B7C : 0000 0000 ....
poolReorgCount: 0
poolLoadCount: 0
poolBackupCount: 0
addrInfo:
0x13898B8C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898B9C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898BAC : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898BBC : 0000 0000 0000 0000 ........
autoResize:
0x13898CFC : 0000 0000 0000 0000 0020 0000 FFFF FFFF ......... ......
0x13898D0C : 0000 0000 FFFF FFFF FFFF FFFF 0000 0000 ................
0x13898D1C : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898D2C : 00CC 0600 0000 0000 FEAB 0000 0100 0000 ................
0x13898D3C : 0000 0000 ....
rebalInfo:
0x13898BC4 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x13898BD4 : 0000 0000 0000 0000 0000 0000 ............
lifeLSN: 00000000000C
LoadPendingLSN: 000000000000
loadRecoveryLSN: 000000000000
begin_LSN: 000000000000
end_LSN: 000000000000
storDefLSN: 000000000000
containerLSN: 00000000000C
updateMRT_LSN: 000000000000
minimumPageLSN: 000000000000
fullBackupLSN: 000000000000
lastBackupLSN: 000000000000
fileRefreshCounter: 0
backupCount: 0
fullBackupTime: 0
lastBackupTime: 0
maxStripeSet: 0
maxContsInStripeSet: 0
n_containers: 1
current_group: 0
container: 0x13899650
cont_mem_used: 0
cont_csum: 308106444
current_map_entries: 0
current_map_size: 0
current_map_entry_size: 0
currMapSzForRebal: 0
current_map: 0x00000000
new_map_entries: 0
new_map_entry_size: 0
new_map_size: 0
new_map: 0x00000000
trigger: 0
pauseCount: 0
trigger_latch:
{
lock = { 0x00 [ unlocked ] }
identity = SQLB_POOL_CB::trigger_latch (188)
}
rebal_to_agent:
0x13898C88 : 0000 0000 00CC 0600 0000 0000 FEAB 0000 ................
0x13898C98 : 0100 0000 0000 0000 ........
agent_to_rebal:
0x13898CA0 : 0000 0000 00CC 0600 0000 0000 FEAB 0000 ................
0x13898CB0 : 0100 0000 0000 0000 ........
waitpost_flags: 7
backupEndEID: 0
rfr_seq: 0
pointInTime: 0
backup_rec_found: 16
minimumRecTime: 0
logAtBkp:
0x13898CD0 : 0000 0000 0000 0000 0000 0000 ............
map_csum: 0
max_sms_size: 0
fsCaching: 0
errorDuringRedo: 0
alterList: 0x00000000
contOpsEntry: 0x00000000
tbspaceParallelism: 0

2007-09-14-13.45.16.613479+480 I19802G784 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbASDefineContainersForDMS, probe:20
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".
DATA #1 : String, 11 bytes
SYSCATSPACE
DATA #2 : Pool ID, PD_TYPE_SQLB_POOL_ID, 2 bytes
0
DATA #3 : unsigned integer, 4 bytes
1
DATA #4 : unsigned integer, 4 bytes
0
DATA #5 : unsigned integer, 4 bytes
8192
DATA #6 : unsigned integer, 1 bytes
0
DATA #7 : Boolean, 1 bytes
true

2007-09-14-13.45.16.613898+480 I20587G497 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSCreatePool, probe:797
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2007-09-14-13.45.16.614101+480 I21085G370 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSCreatePool, probe:797
DATA #1 : String, 7 bytes
Page=0

2007-09-14-13.45.16.614241+480 I21456G494 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, buffer pool services, sqlbCreatePool, probe:950
MESSAGE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2007-09-14-13.45.16.616968+480 I21951G490 LEVEL: Severe
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, data management, sqldPoolCreate, probe:273
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2007-09-14-13.45.16.617264+480 I22442G488 LEVEL: Error
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqleStartDb, probe:38
RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"
DIA8701C Access denied for resource "", operating system return code
was "".

2007-09-14-13.45.16.617456+480 I22931G416 LEVEL: Severe
PID : 11076 TID : 3086890688 PROC : db2agent (idle) 0
INSTANCE: db2inst1 NODE : 000
APPHDL : 0-40 APPID: *LOCAL.db2inst1.070914054230
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqleStartDb, probe:40
DATA #1 : Hexdump, 4 bytes
0xBFE9820C : 0100 0F84 ....
b***@to.com
2007-09-14 06:53:36 UTC
Permalink
Well, could you check if the instance owner user can create a file called "/tmp/SQLDIR.LK0"? In fact, the user should have write access to "/tmp" in general...

Hope this helps,
Bogdan
z***@gmail.com
2007-09-14 07:18:45 UTC
Permalink
Hey Thanks a lot,Problem solved^o^
Regards

Loading...