Additional application server(dialog instance) installation

[Former Member]

Hi all,

I am using Zlinux on DB2 9.1

Trying to install additional application(dialog instance) and the stage start instance it dumping with error.

I tried R3trans -x and the output is below -

4 ETW000 R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).

4 ETW000 unicode enabled version

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

4 ETW000

4 ETW000 date&time : 28.06.2010 - 11:55:40

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] Mon Jun 28 11:55:40 2010

70 0.000070

4 ETW000 [dev trc ,00000] db_con_init called

19 0.000089

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

37 0.000126

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/PE1/SYS/exe/run/dbd

b2slib.so' ... 30 0.000156

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/PE1/SYS/ex

e/run/dbdb2slib.so"), hdl 0

4 ETW000

378 0.000534

4 ETW000 [dev trc ,00000] Library '/usr/sap/PE1/SYS/exe/run/dbdb2slib.so'

loaded 19 0.000553

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sa

p/PE1/SYS/exe/run/dbdb2slib.so

4 ETW000

29 0.000582

4 ETW000 [dev trc ,00000] Version of '/usr/sap/PE1/SYS/exe/run/dbdb2slib.s

o' is "700.08", patchlevel (0.63)

4 ETW000

49 0.000631

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/s

ap/PE1/SYS/exe/run/dbdb2slib.so

4 ETW000

24 0.000655

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/

sap/PE1/SYS/exe/run/dbdb2slib.so

4 ETW000

49 0.000704

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

25 0.000729

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DI

SCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_

max = 255, con_opt = 255, occ = NO

4 ETW000

43 0.000772

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

17 0.000789

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

for reuse: 15 0.000804

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DIS

CONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_

max = 255, con_opt = 255, occ = NO

4 ETW000

39 0.000843

4 ETW000 [dev trc ,00000] dbs/db2/use_accounting != 1 -> DB2 accounting is

switched off 67 0.000910

4 ETW000 [dev trc ,00000] dbs/db2/use_drda_lob_handling != 1 -> SAP LOB ha

ndling is used 18 0.000928

4 ETW000 [dev trc ,00000] dbs/db2/opt2_hint = 0 -> implicit 'optimize for

1 rows' is switched on

4 ETW000

27 0.000955

4 ETW000 [dev trc ,00000] dbs/db2/rs_by_hint = 1 -> isolation level RS by

hint is switched on 16 0.000971

4 ETW000 [dev trc ,00000] dbs/db2/chaining = 20 -> CLI CHAIN optimization

is switched on 22 0.000993

4 ETW000 [dev trc ,00000] DB2Trace: valid syntax for parameter dbs/db2/nup

d_stop: <reason1>,<reason2>,...<reasonn>; length of reason = 8

4 ETW000

27 0.001020

4 ETW000 [dev trc ,00000] DB2Trace: List of reason codes for parameter dbs

/db2/nupd_stop 41 0.001061

4 ETW000 [dev trc ,00000] DB2Trace: 00C90096

17 0.001078

4 ETW000 [dev trc ,00000] DB2Trace: 00C20031

16 0.001094

4 ETW000 [dev trc ,00000] DB2Trace: 00E7000F

16 0.001110

4 ETW000 [dev trc ,00000] DB2Trace: 00C20255

17 0.001127

4 ETW000 [dev trc ,00000] DB2Trace: 00C900A5

16 0.001143

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("libdb2.so"), hdl 1

5464 0.006607

4 ETW000 [dev trc ,00000] SQL DRIVER VERSION is "09.01.0003"

1418 0.008025

4 ETW000 [dev trc ,00000] DB2Connect driver identified as THIN CLIENT

30 0.008055

4 ETW000 [dev trc ,00000] DBSLHA: Default Failover profile /usr/sap/PE1/SY

S/global/connect.ini is used

4 ETW000

250 0.008305

4 ETW000 [dev trc ,00000] DBSLHA: Using new Failover Support

18 0.008323

4 ETW000 [dev trc ,00000] DBSLHA: Using user( pe1adbc) and password(<pwd>)

from password service.

4 ETW000

371 0.008694

4 ETW000 [dev trc ,00000] DBSLHA:

36 0.008730

4 ETW000 [dev trc ,00000] DBSLHA:Connection List

19 0.008749

4 ETW000 [dev trc ,00000] DBSLHA:

16 0.008765

4 ETW000 [dev trc ,00000] DBSLHA:NAME |HOST |SSID|COLLECTION |P

LAN |PORT |SCHEMA |OWNER |LOCATION |RETRY|SLEEP|

4 ETW000

31 0.008796

4 ETW000 [dev trc ,00000] DBSLHA:--

---

|

---

||--

---

|-

-

---

|--

---

|

---

|

---

|

---

|-|---|

4 ETW000

30 0.008826

4 ETW000 [dev trc ,00000] DBSLHA:PE11_on_PR|prd1 |PE11|SAP<DB2Conne|

PE1AECC

PE1AECC

PE1NYPD

00003

00000

4 ETW000

34 0.008860

4 ETW000 [dev trc ,00000] DBSLHA:--

---

|

---

||--

---

|-

-

---

|--

---

|

---

|

---

|

---

|-|---|

4 ETW000

30 0.008890

4 ETW000 [dev trc ,00000] Profile parameter dbs/db2/cli_trace_dir is not s

et 19 0.008909

4 ETW000 [dev trc ,00000] Connecting to <PE11_on_PRD1> on connection 0 ...

20 0.008929

4 ETW000 [dev trc ,00000] DB2TRC: 00 000000 CLI_ALLOC_ENV 1

2566 0.011495

4 ETW000 [dev trc ,00000] DB2TRC: 00 000000 CLI_ALLOC_DBC 1

123 0.011618

4 ETW000 [dbdb2cli ,00000] *** ERROR => DB2 Call 'SQLConnect' Error: sqlcode = -30082 : [IBM][CLI Driver] SQL30082N Security processing failed with reason

"24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

4 ETW000

15493 0.027111

4 ETW000 [dev trc ,00000] DB2TRC: 00 000000 CLI_FREE_DBC 1 63

0.027174

4 ETW000 [dev trc ,00000] DB2TRC: 00 000000 CLI_FREE_ENV 1 48

0.027222

4 ETW000 [dbsldb2. ,00000] *** ERROR => CONNECT failed with sql error '-30082' 19

0.027241

2EETW169 no connect possible: "DBMS = DB2/MVS --- "

[joerg_maier · Accepted solution]

Hi,

Please check the environment variable DB2DB6EKEY. It needs to be the same value on both (CI and DI), or the decryption of the password will fail.

If the keys are different, please read SAP Note 963703 and the referenced Notes that match your installation media.

Regards, Joerg

[Former Member · Accepted solution]

Hi,

At both end the variable is same but on CI its in capital letter and on DI side the value is in lower case.

Is it case sensitive ???

I tried setting it up bt again its changes to lower case..

Do you knw the file name from where the DI is picking variable "DB2DB6EKEY", so that I can directly modify it in tht file itself.

Regards

[joerg_maier · Accepted solution]

Hi,

The key is case sensitive.

Most SAPinst versions support non-default DB2DB6EKEY values by specifying the parameter as an environment variable (When installin a DI for a non-default value on the CI). As well with your situation (db connect while installing dialog instance fails), there are detailed descriptions in the SAP note i referenced (963703) and the Notes referenced there.

Regards, Joerg

Edited by: Joerg Maier on Jun 29, 2010 3:56 PM