Hi, All

I install DB2 9.5.3b on Solaris 10 u6 x64 sparse-root zone and when i try to start instance i get SQL1042C

But in db2diag.log is nothing related with this error

What can be wrong ?

Thank's

Long shot: try "db2iupd <instance>" as root.

Thank you.

But it's not help me, the same SQL1042C

Also, in diaglog presented next errors :


2009-03-25-14.29.58.576085+180 I5417E1042 LEVEL: Error
PID : 17356 TID : 1 PROC : db2fm
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, Generic Registry, GenRegFile::OpenReg, probe:8
MESSAGE : ECF=0x900001C0=-1879047744=ECF_GENREG_OPEN_OUTPUT_FILE_FAILED
Failed to open the output registry
CALLED : OS, -, fopen
RETCODE : ECF=0x90000513=-1879046893=ECF_GENREG_REGISTRY_DOESNT_EXIST
The registry does not exist.
DATA #1 : String, 39 bytes
/export/home/db2inst1/sqllib/global.reg
CALLSTCK:
[0] 0xFFFFFD7FFEF9F0E4 ossLogRC + 0x5E4
[1] 0xFFFFFD7FFF3629EC __1cKGenRegFileHOpenReg6ML_I_ + 0x1EC
[2] 0xFFFFFD7FFF35ACBE __1cJGenRegBinDGet6MLpv1_I_ + 0x11E
[3] 0x0000000000407CB4 __1cQfmGetInstallPath6Fpc0_I_ + 0x134
[4] 0x0000000000404F9E main + 0x48E
[5] 0x0000000000403EAC _start + 0x6C
[6] 0x0000000000000000 ?unknown + 0x0
[7] 0x0000000000000000 ?unknown + 0x0
[8] 0x0000000000000000 ?unknown + 0x0
[9] 0x0000000000000000 ?unknown + 0x0

2009-03-25-14.29.58.938226+180 I6460E604 LEVEL: Warning
PID : 17356 TID : 1 PROC : db2fm
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, Fault Monitor Facility, fmGetInstallPath, probe:30
MESSAGE : ECF=0x90000397=-1879047273=ECF_FM_FAIL_TO_GET_GLOBAL_REG_INST_REC
Failed to get the instance record from the global registry file
CALLED : DB2 Common, Generic Registry, GenRegBin::Get
RETCODE : ECF=0x90000513=-1879046893=ECF_GENREG_REGISTRY_DOESNT_EXIST
The registry does not exist.
DATA #1 : String, 8 bytes
db2inst1

2009-03-25-14.29.58.947762+180 I7065E927 LEVEL: Error
PID : 17356 TID : 1 PROC : db2fm
INSTANCE: db2inst1 NODE : 000
EDUID : 1
FUNCTION: DB2 Common, Fault Monitor Facility, fmGetInstallPath, probe:60
MESSAGE : ECF=0x90000521=-1879046879=ECF_FM_NO_PERMISSION_TO_INSTALL_PATH
No proper access permisions to the install path
DATA #1 : String, 0 bytes
Object not dumped: Address: 0xFFFFFD7FFFDFA860 Size: 0 Reason: Zero-length data
CALLSTCK:
[0] 0xFFFFFD7FFEF9FD55 ossLogSysRC + 0xBC5
[1] 0xFFFFFD7FFEF9EAE4 ossLog + 0x354
[2] 0x0000000000407E09 __1cQfmGetInstallPath6Fpc0_I_ + 0x289
[3] 0x0000000000404F9E main + 0x48E
[4] 0x0000000000403EAC _start + 0x6C
[5] 0x0000000000000000 ?unknown + 0x0
[6] 0x0000000000000000 ?unknown + 0x0
[7] 0x0000000000000000 ?unknown + 0x0
[8] 0x0000000000000000 ?unknown + 0x0
[9] 0x0000000000000000 ?unknown + 0x0


But i can't figure out which proper permissions is needed on install path (/opt/IBM/db2/V9.5)

Is /opt inherited from the global zone? Is /export/home?

Hi, Nick

From global zone it's look like :

/export/db2zone/root/opt/IBM/db2/V9.5

Is it correct ?

So, /opt is inherited from the global zone. As far as I know, non-global zones have read-only access to the inherited stuff.

Hi, Nick

Thank you for your help.

Sorry, but i'm not so familiar with Solaris
Can you, please, tell me how i can resolve this situation ?

Is whole-root zone creation can help ?

I read
How to use DB2 V8.2 in Solaris 10 Zones - Jignesh Shah's Weblog

But if i rigth understand this is also (like in my case) sparse zone used.

Thank you.

I'm not very familiar with Solaris zones either. However, if I understand it correctly, a sparse zone, when it uses inherited file systems from the global zone, uses those file systems in read-only mode. I think the solution would be to install DB2 in the filesystem that belongs to its own zone, not in the global zone.