10 Replies Latest reply: May 18, 2010 6:33 AM by rudi adiwidjaja RSS

DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10007N Message "0" could

rudi adiwidjaja
Currently Being Moderated

Dear Expert,

 

I am installing App server using sapinst with SUSE 10 SP2 DB2 v.9.5FP4 to the DB/CI server with AIX 5.3 DB2 V.9.5FP4, the installation has been on last phase (starting the instance), however the instance can not started up. I run R3trans -d and got the RC 0012, the trans.log says:

 

4 ETW000  [dev trc     ,00000]  Supported features:                                   12  3.250281

4 ETW000  [dev trc     ,00000]  ..retrieving configuration parameters                  8  3.250289

4 ETW000  [dev trc     ,00000]  ..done                                                71  3.250360

4 ETW000  [dev trc     ,00000]  *** ERROR in DB6Connect[dbdb6.c, 1640] CON = 0 (BEGIN)

4 ETW000                                                                          230072  3.480432

4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10007N Message "0" could not be retrieved.       Reason code: "3

4 ETW000                                                                              21  3.480453

4 ETW000  [dev trc     ,00000]  &+                                                                               

4 ETW000                                                                              14  3.480467

4 ETW000  [dev trc     ,00000]  &+                                                                               

4 ETW000                                                                              38  3.480505

4 ETW000  [dev trc     ,00000]  &+                                                                               

4 ETW000                                                                              11  3.480516

4 ETW000  [dev trc     ,00000]  *** ERROR in DB6Connect[dbdb6.c, 1640] (END)           6  3.480522

4 ETW000  [dbdb6.c     ,00000]  *** ERROR => DbSlConnect to 'P01' as 'sapr3' failed

4 ETW000                                                                              81  3.480603

2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'P01'"

 

I copy the last part of sapinst.log:

WARNING 2010-05-07 18:06:06.792

Execution of the command "/usr/sap/P01/SYS/exe/run/startsap all D88 Appslinux"                     finished with return code 6. Output:

 

Checking db Database

-


ABAP Database is not available via R3trans

 

Starting SAP-Collector Daemon

-


18:06:06 07.05.2010   LOG: Effective User Id is root

***********************************************************************

  • This is Saposcol Version COLL 20.95 700 - v2.12, AMD/Intel x86_64 with Linux                    , 2008/01/02

  • Usage:  saposcol -l: Start OS Collector

  •         saposcol -k: Stop  OS Collector

  •         saposcol -d: OS Collector Dialog Mode

  •         saposcol -s: OS Collector Status

  • The OS Collector (PID 24048) is already running .....

************************************************************************

saposcol already running

ABAP Database db must be started on remote server

 

WARNING[E] 2010-05-07 18:06:06.810

CJS-20022  Could not start instance 'D88' of SAP system P01.

 

WARNING[E] 2010-05-07 18:06:06.919

CJS-20022  Could not start instance 'D88' of SAP system P01.

 

ERROR 2010-05-07 18:07:04.728

FCO-00011  The step start with step key |NW_DI|ind|ind|ind|ind|0|0|NW_DI_Insta                    nce|ind|ind|ind|ind|10|0|start was executed with status ERROR .

 

Please assist me to solve the problem.

 

Thanks and Regards,

Rudi

  • Re: DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10007N Message "0" could
    Paul Power
    Currently Being Moderated

    Hi Rudi,

     

    What is the corresponding entry in the db2diag.log from the time of the SQL10007N Message ?

     

    It seems like something has gone wrong during the db installation unfortunately. Did you install the database through sapinst or separately?

     

    You need to check if the instance was actually created or not:

     

    Can you please do the following :                 

       Log in to the db2 system as db2<sid> and collect following:                  

       Collect output of db2level                                                 

       Collect output of env                                                      

       Can you confirm what is the home directory of db2<sid>                       

       ls -l of all the directory and subdirectory of db2<sid>'s home directory including /sqllib/adm directory                                             

       Run db2start command as see what happens.                                  

       output of id command

                                                            

    And if PATH variable of db2<sid> has                      

    <instancehome>/sqllib/adm there.

     

    Check the sapinst_dev.log to see if it mentions instance creation.

     

    It may be that sqllib was there from before and installation did not    

    try the db2icrt to create the instance.  If it tried any any problem    

    occurred then we should get db2icrt.log.... in /tmp directory.  Can you 

    check if it is there.  If it is there then we need to check this. If    

    there is no db2icrt log, then we can tell that before installing        

    db2ilist was showing db2<sid> and sapinst did not try to create the instance.

     

    Hope this helps,

    Paul

    • Re: DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10007N Message "0" could
      rudi adiwidjaja
      Currently Being Moderated

      Hi Paul,

       

      I tried to do it manually, i copied all the user environment from DB/CI server (AIX) which is under /home/p01adm, /home/sapr3, /home/sapp01 and db2/P01. I  also installed db client server manually under /opt/ibm/db2/V9.5 and R3trans -d is now connected (RC 0000), however the command startsap can not be executed and linux command can not be run, even running ls command is not able.

       

      As you can see below:

      Appslinux /# su - p01adm

      uname: Command not found.

      hostname: Command not found.

      uname: Command not found.

      uname: Command not found.

      uname: Command not found.

      uname: Command not found.

      stty: Command not found.

      uname: Command not found.

      hostname: Command not found.

      hostname: Command not found.

      hostname: Command not found.

      hostname: Command not found.

      sh: Command not found.

      uname: Command not found.

      uname: Command not found.

      hostname: Command not found.

      uname: Command not found.

      uname: Command not found.

      uname: Command not found.

      uname: Command not found.

      stty: Command not found.

      uname: Command not found.

      hostname: Command not found.

      hostname: Command not found.

      hostname: Command not found.

      hostname: Command not found.

      hostname: Command not found.

      uname: Command not found.

      hostname: Command not found.

      hostname: Command not found.

      sh: Command not found.

      uname: Command not found.

       

      :p01adm 1> ls -l

      ls: Command not found.

       

      :p01adm 2> export

      CORRECT>exports (y|n|e|a)? yes

      /etc/exports: Permission denied.

       

      :p01adm 3> startsap

      /usr/sap/P01/SYS/exe/run/startsap: line 132: uname: command not found

      /usr/sap/P01/SYS/exe/run/startsap: line 566: uname: command not found

      /usr/sap/P01/SYS/exe/run/startsap: line 571: hostname: command not found

       

      Please advise to fix the issue.

       

      Regards,

      Rudi

      • Re: DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10007N Message "0" could
        Tianxiang (Denny) Liao
        Currently Being Moderated

        >

        rudi adiwidjaja wrote:

         

        > Hi Paul,

        >

        > I tried to do it manually, i copied all the user environment from DB/CI server (AIX) which is under /home/p01adm, /home/sapr3, /home/sapp01 and db2/P01. I  also installed db client server manually under /opt/ibm/db2/V9.5 and R3trans -d is now connected (RC 0000), however the command startsap can not be executed and linux command can not be run, even running ls command is not able.

         

         

        you cannot use user environment of your DBCI (AIX) in Linux environment. I assume your db client wasn't installed properly, you just need to fix this.

         

        what's your installation master version, I had similar issue (db client was not installed properly) with NW 70 SR3,  I ended up with install the client manually.

        • Re: DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10007N Message "0" could
          rudi adiwidjaja
          Currently Being Moderated

          Hi Denny,

           

          Ii use BS 7.0 SR3 and the installation of DB client is finish successfully.

           

          Please advise.

           

          Regards,

          Rudi

          • Re: DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10007N Message "0" could
            Paul Power
            Currently Being Moderated

            Hi,

             

            Could you post the entry of the latest trans.log ?

            What is the contents of the db2diag.log?

             

            Regards,

            Paul

            • Re: DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10007N Message "0" could
              rudi adiwidjaja
              Currently Being Moderated

              Hi Paul,

               

              Here is the trans.log:

              4 ETW000 R3trans version 6.14 (release 700 - 14.02.08 - 14:55:00).

              4 ETW000 ===============================================

              4 ETW000

              4 ETW000 date&time   : 14.05.2010 - 17:10:13

              4 ETW000 control file: <no ctrlfile>

              4 ETW000 R3trans was called as follows: R3trans -d

              4 ETW000  trace at level 2 opened for a given file pointer

              4 ETW000  [dev trc     ,00000]  Fri May 14 17:10:13 2010                           26153  0.026153

              4 ETW000  [dev trc     ,00000]  db_con_init called                                  5927  0.032080

              4 ETW000  [dev trc     ,00000]  create_con (con_name=R/3)                           3911  0.035991

              4 ETW000  [dev trc     ,00000]  Loading DB library '/usr/sap/P01/SYS/exe/run/dbdb6slib.so' ...

              4 ETW000                                                                            2845  0.038836

              4 ETW000  [dev trc     ,00000]  load shared library (/usr/sap/P01/SYS/exe/run/dbdb6slib.so), hdl 0

              4 ETW000                                                                           14871  0.053707

              4 ETW000  [dev trc     ,00000]  Library '/usr/sap/P01/SYS/exe/run/dbdb6slib.so' loaded

              4 ETW000                                                                              32  0.053739

              4 ETW000  [dev trc     ,00000]  function DbSlExpFuns loaded from library /usr/sap/P01/SYS/exe/run/dbdb6slib.                   so

              4 ETW000                                                                            5397  0.059136

              4 ETW000  [dev trc     ,00000]  Version of '/usr/sap/P01/SYS/exe/run/dbdb6slib.so' is "700.08", patchlevel (                   0.144)

              4 ETW000                                                                             146  0.059282

              4 ETW000  [dev trc     ,00000]  function dsql_db_init loaded from library /usr/sap/P01/SYS/exe/run/dbdb6slib                   .so

              4 ETW000                                                                              19  0.059301

              4 ETW000  [dev trc     ,00000]  function dbdd_exp_funs loaded from library /usr/sap/P01/SYS/exe/run/dbdb6sli                   b.so

              4 ETW000                                                                              19  0.059320

              4 ETW000  [dev trc     ,00000]  New connection 0 created                            7179  0.066499

              4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = -000000001 state = DISCONNECTED, perm = YES, reco =                    NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

              4 ETW000                                                                              33  0.066532

              4 ETW000  [dev trc     ,00000]  db_con_connect (con_name=R/3)                         63  0.066595

              4 ETW000  [dev trc     ,00000]  find_con_by_name found the following connection for reuse:

              4 ETW000                                                                              25  0.066620

              4 ETW000  [dev trc     ,00000]  0: name = R/3, con_id = 000000000 state = DISCONNECTED, perm = YES, reco = N                   O , timeout = 000, con_max = 255, con_opt = 255, occ = NO

              4 ETW000                                                                              12  0.066632

              4 ETW000  [dev trc     ,00000]  Fri May 14 17:10:31 2010                         17466052  17.532684

              4 ETW000  [dev trc     ,00000]  DB2 library successfully loaded DB2 library '/usr/sap/P01/SYS/global/db6/LIN                   UXX86_64/db6_clidriver/lib64/libdb2.so' successfully loaded

               

              4 ETW000  [dev trc     ,00000]    (0.41) DB6: add V9 to list of supported DB2 releases (note 912386)

              4 ETW000                                                                              16  17.533104

              4 ETW000  [dev trc     ,00000]    (0.50) DB6: reread passwords for secondary connections (note 931742)

              4 ETW000                                                                              19  17.533123

              4 ETW000  [dev trc     ,00000]    (0.52) DB6: double quote table names in optguidelines (note 868888)

              4 ETW000                                                                              10  17.533133

              4 ETW000  [dev trc     ,00000]    (0.54) DB6: error handling in DBSL CLP (note 940260)

              4 ETW000                                                                               9  17.533142

              4 ETW000  [dev trc     ,00000]    (0.69) DB6: technical support of DB2 CLI driver (note 962892)

              4 ETW000                                                                              20  17.533162

              4 ETW000  [dev trc     ,00000]    (0.73) DB6: log table name on TRUNCATE failure (note 970743)

              4 ETW000                                                                              15  17.533177

              4 ETW000  [dev trc     ,00000]    (0.79) DB6: column type XML in index size calculation (note 982993)

              4 ETW000                                                                              50  17.533227

              4 ETW000  [dev trc     ,00000]    (0.82) DB6: CAST for SSTRING data types (note 989568)

              4 ETW000                                                                              21  17.533248

              4 ETW000  [dev trc     ,00000]    (0.86) DB6: long runtimes for R3szchk (note 1000847)

              4 ETW000                                                                              10  17.533258

              4 ETW000  [dev trc     ,00000]    (0.88) DB6: patch collection Dec 06 (note 1005574)

              4 ETW000                                                                              10  17.533268

              4 ETW000  [dev trc     ,00000]    (0.96) DB6: patch collection Jan 07 (note 1017852)

              4 ETW000                                                                              10  17.533278

              4 ETW000  [dev trc     ,00000]    (0.97) DB6: CLP commands with DB2 CLI Driver (note 1024102)

              4 ETW000                                                                              24  17.533302

              4 ETW000  [dev trc     ,00000]    (0.99) DB6: SUBSTITUTE VALUES with FAE statements (note 1028779)

              4 ETW000                                                                              15  17.533317

              4 ETW000  [dev trc     ,00000]    (0.107) DB6: patch collection Apr 07 (note 1047194)

              4 ETW000                                                                              11  17.533328

              4 ETW000  [dev trc     ,00000]    (0.110) DB6: SAP user names ending with non-ASCII char (note 1054555)

              4 ETW000                                                                              17  17.533345

              4 ETW000  [dev trc     ,00000]    (0.113) DB6: work process type in application snapshot (note 1059905)

              4 ETW000                                                                              15  17.533360

              4 ETW000  [dev trc     ,00000]    (0.114) DB6: connect using SAPDBHOST and DB2DB6_SVCENAME (note 1062049)

              4 ETW000                                                                              10  17.533370

              4 ETW000  [dev trc     ,00000]    (0.117) DB6: patch for execution of long DDL statements (note 1069658)

              4 ETW000                                                                              10  17.533380

              4 ETW000  [dev trc     ,00000]    (0.122) DB6: SNAPSHOT_TBS_CFG table function is deprecated (note 1077963)

              4 ETW000                                                                              11  17.533391

              4 ETW000  [dev trc     ,00000]    (0.123) DB6: CLP commands on Windows with V9.1 (note 1080149)

              4 ETW000                                                                               9  17.533400

              4 ETW000  [dev trc     ,00000]    (0.124) DB6: Set DB2CODEPAGE=819 for non-Unicode (note 1084400)

              4 ETW000                                                                              10  17.533410

              4 ETW000  [dev trc     ,00000]    (0.126) DB6: reuse optguidelines on FAE statements (note 1087375)

              4 ETW000                                                                              17  17.533427

              4 ETW000  [dev trc     ,00000]    (0.126) DB6: Enforce DB2CODEPAGE=819 for non-Unicode environments (note 10                   84400)

               

              4 ETW000  [dev trc     ,00000]  Supported features:                                   11  17.533531

              4 ETW000  [dev trc     ,00000]  ..retrieving configuration parameters                  8  17.533539

              4 ETW000  [dev trc     ,00000]  ..done                                                55  17.533594

              4 ETW000  [dev trc     ,00000]  *** ERROR in DB6Connect[dbdb6.c, 1640] CON = 0 (BEGIN)

              4 ETW000                                                                          629023  18.162617

              4 ETW000  [dev trc     ,00000]  &+     DbSlConnectDB6( SQLConnect ): [IBM][CLI Driver] SQL10007N Message "0"                    could not be retrieved.  Reason code: "3

              4 ETW000                                                                              23  18.162640

              4 ETW000  [dev trc     ,00000]  &+                                                                               

              4 ETW000                                                                              10  18.162650

              4 ETW000  [dev trc     ,00000]  &+                                                                               

              4 ETW000                                                                              22  18.162672

              4 ETW000  [dev trc     ,00000]  &+                                                                               

              4 ETW000                                                                              10  18.162682

              4 ETW000  [dev trc     ,00000]  *** ERROR in DB6Connect[dbdb6.c, 1640] (END)           7  18.162689

              4 ETW000  [dbdb6.c     ,00000]  *** ERROR => DbSlConnect to 'P01' as 'sapp01' failed

              4 ETW000                                                                           29775  18.192464

              2EETW169 no connect possible: "DBMS = DB6                              --- DB2DBDFT = 'P01'"

               

              db2diag.log:

              Appslinux:/ # cat /home/db2p01/sqllib/db2dump/db2diag.log

               

              2010-05-11-17.22.22.983278+420 I1E1443             LEVEL: Event

              PID     : 29905                TID  : 47448518138240PROC : db2flacc

              INSTANCE: db2p01               NODE : 000

              FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120

              START   : New Diagnostic Log file

              DATA #1 : Build Level, 152 bytes

              Instance "db2p01" uses "64" bits and DB2 code release "SQL09054"

              with level identifier "06050107".

              Informational tokens are "DB2 v9.5.0.4", "special_21925", "MI00303_21925", Fix Pack "4".

              DATA #2 : System Info, 440 bytes

              System: Linux Appslinux 6 2 x86_64

              CPU: total:4 online:4 Cores per socket:1 Threading degree per core:1

              Physical Memory(MB): total:3777 free:253

              Virtual  Memory(MB): total:16073 free:12549

              Swap     Memory(MB): total:12296 free:12296

              Kernel   Params: msgMaxMessageSize:65536 msgMsgMap:65536 msgMaxQueueIDs:16

                               msgNumberOfHeaders:65536 msgMaxQueueSize:65536

                               msgMaxSegmentSize:16 shmMax:9223372036854775807 shmMin:1

                               shmIDs:4096 shmSegments:4096 semMap:256000 semIDs:8192

                               semNum:256000 semUndo:256000 semNumPerID:1250 semOps:100

                               semUndoSize:20 semMaxVal:32767 semAdjustOnExit:32767

              Cur data size (bytes)  = 0xFFFFFFFF

              Cur stack size (bytes)  = 0x00800000

              Cur core size (bytes)  = 0x00000000

              nofiles (descriptors)  = 0x00000400

               

              Information in this record is only valid at the time when this file was

              created (see this record's time stamp)

               

              2010-05-11-17.22.22.934210+420 I1445E301           LEVEL: Event

              PID     : 29905                TID  : 47448518138240PROC : db2flacc

              INSTANCE: db2p01               NODE : 000

              FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30

              CHANGE  : CFG DBM: "Sysadm_group" From: ""  To: "db2iadm1"

               

              2010-05-11-17.22.28.143700+420 I1747E351           LEVEL: Event

              PID     : 29924                TID  : 47855522437504PROC : db2flacc

              INSTANCE: db2p01               NODE : 000

              FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30

              CHANGE  : CFG DBM: "JDK_path" From: "/home/wsdblnx9/sqllib/java/jdk64"  To: "/home/db2p01/sqllib/java/jdk64"

               

              2010-05-11-17.22.28.336025+420 I2099E316           LEVEL: Event

              PID     : 29932                TID  : 47745664592256PROC : db2flacc

              INSTANCE: db2p01               NODE : 000

              FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30

              CHANGE  : CFG DBM: "Diagpath" From: ""  To: "/home/db2p01/sqllib/db2dump"

               

              2010-05-11-17.22.28.432407+420 I2416E299           LEVEL: Event

              PID     : 29938                TID  : 47455484721536PROC : db2flacc

              INSTANCE: db2p01               NODE : 000

              FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30

              CHANGE  : CFG DBM: "Discover_comm" From: ""  To: "TCPIP"

              Appslinux:/ #

               

              I can not even change the environment, since the command export can not be found.

               

              Please advise.

               

              Regards,

              Rudi

Actions