on 09-04-2013 10:52 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
i had the same problem, try following :
db6_update_client.sh -c AIX_64
db6_update_client.sh -u
BR,
Andreas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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).
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I ran the below command from CLIENT directory in software path
./db6_update_client.sh -u
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.