cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

paul_power
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

>

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

Former Member
0 Kudos

Hi Denny,

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

Please advise.

Regards,

Rudi

paul_power
Active Contributor
0 Kudos

Hi,

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

What is the contents of the db2diag.log?

Regards,

Paul

Former Member
0 Kudos

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

Frank-Martin
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Rudi,

I believe that this is a client related problem. Since your system is using the CLI driver there is a chance that you find some information in the db2diag.log of the client in

/usr/sap/P01/SYS/global/db6/db2diag.log

Regards

Frank

Former Member
0 Kudos

Frank,

The log seems not written since there's no db2diag.log there:

Directory: /usr/sap/P01/SYS/global/db6/db2dump

Appslinux db6/db2dump# ls -l

total 0

Regards,

Rudi

Frank-Martin
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Rudi,

does your config file /usr/sap/SID/SYS/global/db6/db2cli.ini contain the following lines?

[COMMON]

Diagpath=/usr/sap/SID/SYS/global/db6/db2dump

Could you please post the contents of this file?

Maybe taking a trace of "R3trans -x" can give a hint. Do take a trace add the foolwing lines.

[COMMON]

Diagpath=/usr/sap/E72/SYS/global/db6/db2dump

Trace=1

TRACEPATHNAME=/tmp/

Regards

Frank

Former Member
0 Kudos

Dear Frank,

I have dropped the server and tried to attach to Linux server.

Regards,

Rudi