Cannot start SAP with UNIX

[Former Member]

Hi!

I coudn´t started SAP, i have db2 with unix, when i tried with R3trans -d, sent the follow message.

Does anyone have an idea of how to fix this???

Thanks

saprd_drp:prdadm 7> more trans.log

4 ETW000 R3trans version 6.05 (release 46D - 15.03.05 - 16:57:00).

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

4 ETW000

4 ETW000 control file:

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 date&time : 01.06.2007 - 08:32:52

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

4 ETW000 Fri Jun 1 08:32:52 2007

67 0.000067

4 ETW000 db_con_init called

20 0.000087

4 ETW000 create_con (con_name=R/3)

91 0.000178

4 ETW000 Loading DB library '/usr/sap/PRD/SYS/exe/run/dbd

b6slib.o' ...

4 ETW000

75 0.000253

4 ETW000 load shared library (/usr/sap/PRD/SYS/exe/run/db

db6slib.o), hdl 0

4 ETW000

12953 0.013206

4 ETW000 Library '/usr/sap/PRD/SYS/exe/run/dbdb6slib.o' l

oaded

4 ETW000

49 0.013255

4 ETW000 function DbSlExpFuns loaded from library /usr/sa

p/PRD/SYS/exe/run/dbdb6slib.o

4 ETW000

73 0.013328

4 ETW000 Version of library '/usr/sap/PRD/SYS/exe/run/dbd

b6slib.o' is "46D.00", patchlevel (0.2222)

4 ETW000

365 0.013693

4 ETW000 function dsql_db_init loaded from library /usr/s

ap/PRD/SYS/exe/run/dbdb6slib.o

4 ETW000

32 0.013725

4 ETW000 function dbdd_exp_funs loaded from library /usr/

sap/PRD/SYS/exe/run/dbdb6slib.o

4 ETW000

28 0.013753

4 ETW000 New connection 0 created

30 0.013783

4 ETW000 db_con_connect (con_name=R/3)

54 0.013837

4 ETW000 find_con found the following connection for reus

e:

4 ETW000

26 0.013863

4 ETW000 DB6 (DB2 UDB) database interface 46D.00

463 0.014326

4 ETW000 DB6 shared library (dbdb6slib) patchlevels

48 0.014374

4 ETW000 (0.66) Lower isolation level reading cluster t

ables (note 316120)

4 ETW000

93 0.014467

4 ETW000 (0.137) Support for COMMON_TABLE_EXPRESSION (n

ote 324496)

4 ETW000

61 0.014528

4 ETW000 (0.337) Wrong error class for SQL0289; use UPT

O hint (note 363894)

4 ETW000

28 0.014556

4 ETW000 (0.437) Prepare: several mySAP.com components

in one DB (note 379572)

4 ETW000

57 0.014613

4 ETW000 (0.481) Avoid Core Dump in DBSL Trace at CREAT

E TABLE statements (note 386217)

4 ETW000

59 0.014672

4 ETW000 (0.486) DB connect user in lower case letters

(note 388052)

4 ETW000

158 0.014830

4 ETW000 (0.574) 'COMMIT' statements in ST05 trace (not

e 400480)

4 ETW000

60 0.014890

4 ETW000 (0.723) Improved Optlevel Handling (note 42503

5)

4 ETW000

69 0.014959

4 ETW000 (0.761) Allow DB2 V6.1 again (note 429230)

45 0.015004

4 ETW000 (0.814) DB6: DDL autocommit (note 436717)

17 0.015021

4 ETW000 (0.815) DB6: corrupted row in table buffer (no

te 437692)

4 ETW000

25 0.015046

4 ETW000 (0.838) DB6: TRUNCATE TABLE does not work (not

e 443680)

4 ETW000

27 0.015073

4 ETW000 (0.913) DB6: DBIF_RSQL_ERROR_INTERNAL after ma

ss insert (note 453313)

4 ETW000

26 0.015099

4 ETW000 (0.914) DB6: ROLLBACK before disconnect (note

455769)

4 ETW000

57 0.015156

4 ETW000 (0.965) DB6: Missing execution times in DbSl T

race (note 483879)

4 ETW000

59 0.015215

4 ETW000 (0.997) Enable larger IN-Lists (note 493063)

16 0.015231

4 ETW000 (0.1033) DB6: support SUBSTITUTE_LITERALS Hint

(note 150037)

4 ETW000

55 0.015286

4 ETW000 (0.1064) Correct error handling for SQLAllocHa

ndle (note 503564)

4 ETW000

57 0.015343

4 ETW000 (0.1069) Gather CC statistics for ST02 (note 5

05914)

4 ETW000

55 0.015398

4 ETW000 (0.1089) Correct CC statistic values (note 505

914)

4 ETW000

52 0.015450

4 ETW000 (0.1108) Support DECIMAL literals (note 150037

)

4 ETW000

28 0.015478

4 ETW000 (0.1139) Patch for SQLCancel operations (note

520974)

4 ETW000

24 0.015502

4 ETW000 (0.1159) Check for DB2 version mismatch (note

503122)

4 ETW000

28 0.015530

4 ETW000 (0.1237) Free CSTRACE statements (note 548282)

4 ETW000

24 0.015554

4 ETW000 (0.1282) View definition unknown (SE14) (note

555254)

4 ETW000

25 0.015579

4 ETW000 (0.1365) Handling of quotes in literal values

(note 575672)

4 ETW000

28 0.015607

4 ETW000 (0.1372) UPDATE first row on cluster write (no

te 579215)

4 ETW000

25 0.015632

4 ETW000 (0.1440) Ignore warnings in get_dbparms sqlfxd

b() (note 596298)

4 ETW000

25 0.015657

4 ETW000 (0.1506) DBSl patch collection 04/2003 (note 6

18003)

4 ETW000

27 0.015684

4 ETW000 (0.1508) DB6: no autocommit for NOT LOGGED INI

TIALLY statements (note 436717)

4 ETW000

26 0.015710

4 ETW000 (0.1537) DB6: check collating sequence (note 3

76746)

4 ETW000

36 0.015746

4 ETW000 (0.1564) DB6: dynamic load of DB2 libs on AIX,

SOLARIS (note 641036)

4 ETW000

55 0.015801

4 ETW000 (0.1579) DB6: EXEC SQL WITH HOLD: out of handl

es (note 647325)

4 ETW000

53 0.015854

4 ETW000 (0.1588) DB6: corrupted short texts in CStrace

(note 648128)

4 ETW000

28 0.015882

4 ETW000 (0.1589) DB6: release instance attachments (no

te 649139)

4 ETW000

25 0.015907

4 ETW000 (0.1600) Object consistency (note 650475)

16 0.015923

4 ETW000 (0.1607) DB6: ignore SQL0000W warnings ( dbcod

e = 0 ) (note 653463)

4 ETW000

28 0.015951

4 ETW000 (0.1608) DB6: failed Login attempts for sidadm

(note 653573)

4 ETW000

25 0.015976

4 ETW000 (0.1612) DB6: CALL PROCEDURE fix (note 655274)

4 ETW000

25 0.016001

4 ETW000 (0.1630) DB6: new hint 'CONVERT_FAE_TO_CTE' (n

ote 150037)

4 ETW000

28 0.016029

4 ETW000 (0.1637) DB6: multiconnect to DB2/390 database

(note 663756)

4 ETW000

24 0.016053

4 ETW000 (0.1644) DB6: core in buildStmtStr() (note 666

831)

4 ETW000

25 0.016078

4 ETW000 (0.1647) DB6: SQLExtendeBind for DB2 procedure

s (note 668550)

4 ETW000

28 0.016106

4 ETW000 (0.1714) DB6: CLI0125E Function sequence error

on ROLLBACK (note 687453)

4 ETW000

54 0.016160

4 ETW000 (0.1740) DB6: avoid missalignment traps on HP

(note 698223)

4 ETW000

28 0.016188

4 ETW000 (0.1769) DB6: SET CURRENT QUERY OPTIMIZATION (

note 710970)

4 ETW000

25 0.016213

4 ETW000 (0.1796) DB6: multiconnect to DB2/390 or DB2/4

00 database (note 663756)

4 ETW000

58 0.016271

4 ETW000 (0.1851) DB6: CLI LOAD bei INSERT ... FULLSELE

CT (note 737914)

4 ETW000

28 0.016299

4 ETW000 (0.1877) DB6: support OPT_FOR_ROWS 0 hint (not

e 150037)

4 ETW000

25 0.016324

4 ETW000 (0.1930) DB6: SQL0518 statement not in a prepa

red state (note 776540)

4 ETW000

28 0.016352

4 ETW000 (0.1983) DB6: Saturn Patch Collection (note 80

4651)

4 ETW000

25 0.016377

4 ETW000 (0.2024) DB6: check DB2_WORKLOAD=SAP registry

setting (note 825392)

4 ETW000

25 0.016402

4 ETW000 (0.2066) DB6: V8.2.2 optguidelines in OPEN SQL

(note 150037)

4 ETW000

37 0.016439

4 ETW000 (0.2116) DB6: hints: get correlation names fro

m view texts (note 868888)

4 ETW000

25 0.016464

4 ETW000 (0.2136) DB6: optimization guidelines on views

part 2 (note 868888)

4 ETW000

25 0.016489

4 ETW000 (0.2185) DB6: add V9 to list of supported DB2

releases (note 912386)

4 ETW000

28 0.016517

4 ETW000 (0.2211) DB6: no SIMULATE_ERROR after cancel C

BF (note 928565)

4 ETW000

25 0.016542

4 ETW000 (0.2217) DB6: reread passwords for secondary c

onnections (note 931742)

4 ETW000

27 0.016569

4 ETW000 (0.2222) DB6: double quote table names in optg

uidelines (note 868888)

4 ETW000

26 0.016595

4 ETW000 Build includes

42 0.016637

4 ETW000 - smart optlevel handling (non-UR, FAE)

16 0.016653

4 ETW000 - dynamic load of DB2 libraries

52 0.016705

4 ETW000

40 0.016745

4 ETW000 ..retrieving configuration parameters

45 0.016790

4 ETW000 ..done

412 0.017202

4 ETW000 DB2 library /db2/PRD/sqllib/lib64/libdb2.a(shr_6

4.o) successfully loaded

4 ETW000

54573 0.071775

4 ETW000 *** ERROR in DB6Connect[dbdb6.c, 1273]

120388 0.192163

4 ETW000 &+ DbSlConnectDB6( SQLConnect 😞 [CLI D

river] SQL30082N Attempt to establish connection failed with security re

4 ETW000

98 0.192261

4 ETW000 &+ ason "24" ("USERNAME AND/OR PASSWORD INVA

LID"). SQLSTATE=08001

4 ETW000

46 0.192307

4 ETW000 &+

27 0.192334

4 ETW000 &+

28 0.192362

4 ETW000 *** ERROR in DB6Connect[dbdb6.c, 1273]

16 0.192378

4 ETW000 *** ERROR => DbSlConnect to 'PRD' as 'sapr3' fai

led

4 ETW000

89 0.192467

2EETW169 no connect possible: "DBMS = DB6 --- DB2DB

DFT = 'PRD'"

[former_member237781]

Hi,

did you change the password of user "sapr3"

> Attempt to establish connection failed with security reason "24"

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

> *** ERROR => DbSlConnect to 'PRD' as 'sapr3' failed

-- Henning Sackewitz

[Former Member]

Hi Henning!

Thank you for your recommendation, the problem was solved.

Best kind regards.