on 11-02-2012 10:35 AM
Hello All,
I have problem when I tried to run db02. It gives me number of error message such as
1. DQS Error Checking/ Installing UDFs. Return code = ADBC Error.
2. DQS Database is not yet configured for monitoring.
3. DQS Problem with UDF Installations ADBC error.
4. DQS Therefore some function may not work properly.
5. DQS Check the UDF configuration for more details.
6. DQS Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_SNAPSHOT line 447/ RC= ADBC Error.
My Server detalis are as follows
O.S. Windows Server 2008 SR2
Database DB2 9.7.
I have checked the the Library for this Table Function and set the path of that file. and then test the connection.
That is the path of this library is Kernel Executables. But stilll I got this message.
Please checked this
Thanks in advanced.
Amit.
Hi Amit,
What exact fixpack of v9.7 is being used?
What is the basis support package level of the system?
Is there an entry in the system log (SM21) at the time of the error?
If so, is their an entry in the work process trace file that encountered the error?
As the issue mention an error with the UDF, check current udf path level.
Please firstly remove the old UDFand then install it again with the latest patch.
Please refer to the notes:
334777 Missing user-defined functions
921488 db6pmudf - latest patch (currently 19)
978319 DB6: Incorrectly cataloged table functions
regards,
Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Paul,
Thanks for your reply.
DB2 Version: 09.07.0006
Basis Support Package level: Release: 700 Level: 22 SAPKB70022.
There is no any dump shown is System Log.
I have given the path of Executable of Kernel. And test, then it shoes 19 in Version. But still it gives same error.
Can you tell me hoe to chevk Current UDF path Level and how to remove and install latest path level of UDF??
Thanks,
Amit
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
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.