cancel
Showing results for 
Search instead for 
Did you mean: 

Error during CLI driver upgrade

Former Member
0 Kudos

Hi Expertise,

During CLI upgrade I faced the below error id diag.log

2013-09-04-10.45.00.635953+060 E56997A606         LEVEL: Error

PID     : 48103472             TID  : 2853        PROC : db2acd 0

INSTANCE: db2txd               NODE : 000         DB   : TXD

APPID   : *LOCAL.db2txd.130904094503

EDUID   : 2853                 EDUNAME: db2acd 0

FUNCTION: DB2 UDB, Administrative Task Scheduler, AtsTask::executeTask, probe:600

MESSAGE : ZRC=0xFFFFFE4A=-438

DATA #1 : <preformatted>

[IBM][CLI Driver][DB2/AIX64] SQL0438N  Application raised error or warning with diagnostic text: "SQL0438N  Application raised error or warning with diagnostic text: "C".  SQLSTATE=55555

Any idea about this

Accepted Solutions (1)

Accepted Solutions (1)

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

Hi,

i do not see how this message can be related to the client upgrade. The message is related to the DB2 Administrative Task Scheduler . In the SAP environment the DBACOCKPIT scedules periodic DB2 tasks. So I would first check the  DBACOCKPIT configuration.

Regards

               Frank

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

i had the same problem, try following :

db6_update_client.sh -c AIX_64

db6_update_client.sh -u

BR,

Andreas

Former Member
0 Kudos

Also I could see the clidriver folder at the path.which seems to be default path
/usr/sap/<SAPSID>/SYS/global/db6/<OS>/db6_clidriver


DTGBSSC1TXD01:txdadm 30> cd db6
DTGBSSC1TXD01:txdadm 31> ls -lrt
total 8
-rw-r--r--    1 txdadm   sapsys          169 May 22 2012  db2cli.ini
drwxr-x---    3 txdadm   sapsys          256 May 22 2012  AIX_64
drwxr-xr-x    2 txdadm   sapsys          256 Jun 04 2012  db2dump
drwxr-xr-x    2 txdadm   sapsys          256 Sep 04 10:33 jdbc
DTGBSSC1TXD01:txdadm 32> cd AIX_64
DTGBSSC1TXD01:txdadm 33> ls -lrt
total 16
-rwxr-xr-x    1 txdadm   sapsys           14 May 22 2012  clidriver.lst
drwxr-x---   14 txdadm   sapsys         4096 May 22 2012  db6_clidriver

But when I ran the below command from CLIENT directory in software path

./db6_update_client.sh -u

It is searching the CLI driver directory in below path
/usr/sap/<SAPSID>/SYS/global/db6 and not able to find the same normally

DTGBSSC1TXD01:txdadm 13> ./db6_update_client.sh -u

*********************************************************
* this is db6_update_client.sh script version 0008       *
*********************************************************

determined current OS where script is executed: AIX_64


source path: /db2/FIXPACK8/DB2_LUW_9.7_FP8_RDBMS_AIX__HP__SOL_/AIX_64/CLIENT
target path: /usr/sap/TXD/SYS/global/db6

#***************************************************************************#
# updating existing CLI drivers
#***************************************************************************#
no CLI driver directory found under /usr/sap/TXD/SYS/global/db6
Could you please let me know the reason behind


Could you please let me know the reason behind

former_member182505
Contributor
0 Kudos

Hi

could you please give the full permission and try..

is it java system,?

Fallow the steps

1. Log on to the database host as user "<sapsid>adm"

2. Mount the DB2 LUW CLI/JDBC driver

3. Copy the entire content of the DVD to a temporary directory

4. Download the attachment db6_update_client.SAR to the subdirectory

<temp>/CLIENT, and unpack it there using the program SAPCAR.

5. Start the script "db6_update_client.sh" from this directory using the

following command:

./db6_update_client.sh –u

or db6_update_client.sh -j for Java-only systems

Thanks

Sadiq

Former Member
0 Kudos

Hi sadiq,

It is not java only system

I copied the fixpack folder(DB2_LUW_9.7_FP8_RDBMS_AIX__HP__SOL_) in /db2/FIXPACK8 path

Full permission given as per chmod -R 777 .

navigate through to CLIENT folder i.e. /db2/FIXPACK8/DB2_LUW_9.7_FP8_RDBMS_AIX__HP__SOL_/AIX_64/CLIENT

copied latest version of db6_update_client.sh in CLIENT folder

ran the command as

./db6_update_client.sh -u

Do you see any wrong step here,please suggest.

The issue I can see that the db6_update_client.sh is searching for the CLI driver in wrong path than the default one(where actual CLI driver exist).

Former Member
0 Kudos

Hello Somraj,

as pointed out by Frank it looks like an issue with the admin task scheduler, can you please

check if you can access the Scheduled DB2 Tasks screen ?

call the DBA Cockpit and choose -> Jobs  -> Scheduled DB2 tasks


Please also ensure that the DBAcockpit composite note is applied in the system in transaction SNOTE  (depending on Basis release)

1456402 DB6: DBA Cockpit Correction Collection SAP Basis 7.02 / 7.30

1314750 DB6: DBA Cockpit Correction Collection SAP Basis 700 / 710

  1309424 DB6: DBA Cockpit Correction Collection SAP Basis   7.01 / 7.11

.Regards,

Javier

Former Member
0 Kudos

Hi,

Thanks for you valuable suggestion.

No this message not repeted any more.

I saw the below error

[IBM][CLI Driver][DB2/AIX64] SQL0438N  Application raised error or warning with diagnostic text: "SQL0438N  Application raised error or warning with diagnostic text: "C".  SQLSTATE=55555

showing CLI driver so thought it may be related to Client upgrade

I will talk to SAP basis admin(Don't have access to DBACOCKPIT) for this and will raise OSS if required.

Btw any more information will be highly appreciated

former_member182505
Contributor
0 Kudos

Hi Somraj

i dont think this related to client upgrade. I faced this issue in past without any client update.

check your DBACOCKPIT configuration.

and you can get SAP suggestion also

Thanks

Sadiq

Former Member
0 Kudos

Hi,

Thanks for you valuable suggestion.

No this message not repeted any more.

I saw the below error

[IBM][CLI Driver][DB2/AIX64] SQL0438N  Application raised error or warning with diagnostic text: "SQL0438N  Application raised error or warning with diagnostic text: "C".  SQLSTATE=55555

showing CLI driver so thought it may be related to Client upgrade

I will talk to SAP basis admin(Don't have access to DBACOCKPIT) for this and will raise OSS if required.

Btw any more information will be highly appreciated

Former Member
0 Kudos

I ran the below command from CLIENT directory in software path

./db6_update_client.sh -u

former_member182505
Contributor
0 Kudos

Hi Somraj

whats your DB version and FP.

Is the error is repeating?

You can open a oss with sap.

Thanks

Sadiq