dbanalyzer_instanceParametercheck.cfg giving errors

[Former Member]

Hi

I have recently upgraded my Maxdb 7.6 to 7.8.02.21 and patched without any problems. I downloaded the DbanalyzerParamCheck cfg file but iama having the following errors when i try to run it:

wxrr1:wx1adm 40> dbanalyzer -d WX1 -u SUPERDBA;test_1 -f /sapdb/WP1/data/antool/dbanalyzer_instanceParametercheck.cfg -o /sapdb/WX1/data/antool/param_check -i -c 1 -t 1,1 -n wxrr1

MaxDB Database Analyzer, The Performance Analysis Tool, Version 7.6.00.35

Copyright 2000-2006 by SAP AG

Enter password:

ERR 11311 IPC idfile: 'UserProfileContainer(stat)' open error, No such file or directory

ERR -11607 COMMUNIC SqlBasicAuthenticationOnly: illegal reference: 0

ERROR 4: Cannot connect to database.

-709 [SAP AG][LIBSQLOD SO][MaxDB] Unable to connect to data source;-709 CONNECT: (cannot create communication semaphore)

test_1: Command not found.

Any ideas Welcome

I am running this on Linux SLES 10 64 Bit

[former_member229109]

Hello,

1. "I have recently upgraded my Maxdb 7.6 to 7.8.02.21 and patched without any problems. I downloaded the DbanalyzerParamCheck cfg file "

Why you are using the DB analyzer version 7.6.00.35 to check the parameters of the database version 7.8.02.21?

I recommend to use the DB analyzer version 7.8.02.21 located in <Installation DB Path>/bin

Please post output of the commands:

sdbregview -l

xinstinfo WX1

dbmcli inst_enum

dbmcli db_enum

As wx1adm:

env

2. Are you SAP customer?

if yes => Did you follow the SAP Note 1353266 part III section 3. ?

3. Which version of DbanalyzerParamCheck cfg file did you download?

Thank you and best regards, Natalia Khlopina

[Former Member]

Thanks Natalia

Why you are using the DB analyzer version 7.6.00.35 to check the parameters of the database version 7.8.02.21: even if i use ver 7.8.02.21 it still references to ver 7.6.00.35.

sdbregview -l

Installation: Global /sapdb/programs

Global Listener 7.8.02.21 valid 64 bit

Installation Compatibility 7.8.02.21 valid 64 bit

Installer 7.8.02.21 valid

SAP Utilities Compatibility 7.8.02.21 valid 64 bit

Installation: Legacy /sapdb/programs

DB Analyzer /sapdb/programs 7.6.00.35 valid 64 bit

Fastload API /sapdb/programs 7.6.00.35 valid 64 bit

JDBC /sapdb/programs 7.6.00.30 valid

Loader /sapdb/programs 7.6.00.35 valid 64 bit

Messages /sapdb/programs MSG 0.3951 valid

ODBC /sapdb/programs 7.6.00.35 valid 64 bit

PCR 7300 /sapdb/programs 7.3.00.55 valid

PCR 7301 /sapdb/programs 7.3.01.18 valid

PCR 7500 /sapdb/programs 7.5.00.24 valid 64 bit

Redist Python /sapdb/programs 7.6.00.35 valid 64 bit

SQLDBC /sapdb/programs 7.6.00.35 valid 64 bit

SQLDBC 76 /sapdb/programs 7.6.00.35 valid 64 bit

Installation: WX1 /sapdb/WX1/db

Base 7.8.02.21 valid 64 bit

DB Analyzer 7.8.02.21 valid 64 bit

Database Kernel 7.8.02.21 valid 64 bit

Fastload API 7.8.02.21 valid 64 bit

JDBC 7.6.06.07 valid

Loader 7.8.02.21 valid 64 bit

Messages MSG 0.10269 valid

ODBC 7.8.02.21 valid 64 bit

Redist Python 7.8.02.21 valid 64 bit

SAP Utilities 7.8.02.21 valid 64 bit

SQLDBC 7.8.02.21 valid 64 bit

SQLDBC 76 7.6.06.17 valid 64 bit

SQLDBC 77 7.8.02.21 valid 64 bit

Server Utilities 7.8.02.21 valid 64 bit

Installation: CL_WX1 /sapdb/clients/WX1

Base 7.8.01.14 valid 64 bit

Fastload API 7.8.01.14 valid 64 bit

JDBC 7.6.06.07 valid

Messages MSG 0.9004 valid

ODBC 7.8.01.14 valid 64 bit

SAP Utilities 7.8.01.14 valid 64 bit

SQLDBC 7.8.01.14 valid 64 bit

SQLDBC 76 7.6.06.10 valid 64 bit

SQLDBC 77 7.8.01.14 valid 64 bit

xinstinfo WX1

IndepData : /sapdb/data

IndepPrograms : /sapdb/programs

InstallationPath : /sapdb/WX1/db

dbmcli inst_enum

OK

7.8.02.21 /sapdb/WX1/db

7.8.01.14 /sapdb/clients/WX1

dbmcli db_enum

OK

WX1 /sapdb/WX1/db 7.8.02.21 fast running

WX1 /sapdb/WX1/db 7.8.02.21 quick offline

WX1 /sapdb/WX1/db 7.8.02.21 slow offline

WX1 /sapdb/WX1/db 7.8.02.21 test offline

Did you follow the SAP Note 1353266 part III section 3: Yes i updated the kernel with the latest.

Which version of DbanalyzerParamCheck cfg file did you download----i downloaded attached to note 1111426

Regards

[former_member229109]

Hello,

thank you for posted information.

1.

I asked : "Did you follow the SAP Note 1353266 part III section 3. ?"

Please see section "III/ Activities prior to the upgrade" of the note, " 3. UNIX/Linux".

There additional recommendations to check/correct the environment of the user <sid>adm and/or sqd<sid>.

Did you follow those steps?

Post the output of "env" of the user <sid>adm .

2.

You should have the DB analyzer of 7.8 version in /sapdb/WX1/db/bin.

Run /sapdb/WX1/db/bin/dbanalyzer ...

It will show "The Performance Analysis Tool, Version 7.8.02.21".

Regards, Natalia Khlopina

[lbreddemann]

Hi there,

there's a typo in your command:

dbanalyzer -d WX1 -u SUPERDBA;test_1 ....

should be

dbanalyzer -d WX1 -u SUPERDBA,test_1 ....

(replace ; with , to separate the user name from the password)

regards,

Lars

[Former Member]

thanks for the response

iam still getting the same error after putting the , not ;

[lbreddemann]

Could you please load the system tables before ?

E.g. via

dbmcli -d ... -u system,...  load_systab

regards,

Lars