Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2007
    Location
    Moscow
    Posts
    41

    Unanswered: db2start -> SQL1042C

    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

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Long shot: try "db2iupd <instance>" as root.

  3. #3
    Join Date
    Sep 2007
    Location
    Moscow
    Posts
    41
    Thank you.

    But it's not help me, the same SQL1042C

  4. #4
    Join Date
    Sep 2007
    Location
    Moscow
    Posts
    41
    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)

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Is /opt inherited from the global zone? Is /export/home?
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Sep 2007
    Location
    Moscow
    Posts
    41
    Hi, Nick

    From global zone it's look like :

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

    Is it correct ?

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    So, /opt is inherited from the global zone. As far as I know, non-global zones have read-only access to the inherited stuff.
    ---
    "It does not work" is not a valid problem statement.

  8. #8
    Join Date
    Sep 2007
    Location
    Moscow
    Posts
    41
    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.

  9. #9
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •