473,396 Members | 1,757 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

DB2 External procedure: SQLJ.INSTALL_JAR failing

hello team,
I am new to DB2 procedures, and want to install ibm_tivoli-ncm_db2_udf.jar, in my DB2 9.7 server on RHEL 6.5.

Command used::* db2 "CALL SQLJ.INSTALL_JAR(’file:/home/ncmdbusr/ibm_tivoli-ncm_db2_udf.jar’, ncm_db2_udf)"

error msg:: SQL20200N* The install or replace of "NCMDBUSR.NCM_DB2_UDF" failed as
"’file:/home/ncmdbusr/ibm_tivoli-ncm_db2_udf.jar" could not be located.SQLSTATE=46001

I am connected to Database, and schema has been set.
The required jar file is present in the defined location:: /home/ncmdbusr/ibm_tivoli-ncm_db2_udf.jar, and can be located using ls command, but still the procedure giving the above error.

ncmdbusr has all the permissions on the file and has been grant with all access rights to Db.
Please help in solving this issue.

If I want to manually install the jar file, what steps should i follow?

If any one can explain the steps taken by SQLJ.INSTALL_JAR procedure to install, will be great help.

Thanx
nikki
May 13 '15 #1
1 2149
Team, please reply, if any one have any idea about this scenario.

Thanx
May 19 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Lisa Tang | last post by:
Hi, I am trying to call a C function from PL/SQL and I encounter "ORA-06525 Length Mismatch for CHAR or RAW data". Following is the information: C function in util.dll: INT Scramble(BYTE...
3
by: Carlo Chung | last post by:
Hi, I have a question about how to retrieve the information of the calling instance, such as instance name, in an external C procedure. Thank you, Carlo Chung
2
by: Peter Sullvan | last post by:
We have a few rather advanced calculation routines developed in C++. Currently we are using a Sybase ASA database for our app. and these routines are accessible by so called external functions...
4
by: Paul Reddin | last post by:
Hi, (V8.1 FP2) Trying to run SQLJ.INSTALL_JAR, we get the following error SQL1131N DARI (Stored Procedure) process has been terminated abnormally. SQLSTATE=38503 Not sure why this has...
5
by: Raquel | last post by:
This is a very simple DB2 SQLJ stored procedure. The problem is that it seems to run fine but returns NOTHING. I mean..as if nothing has happened..not resultset is returned. I am passing value...
1
by: Uma | last post by:
DB2I.PROCEDURE1 - Build started. C:\SQLLIB\java\jdk\bin\javac -classpath ".;C:\SQLLIB\java\db2java.zip;C:\SQLLIB\java\runtime.zip;C:\SQLLIB\java\sqlj.zip" "PROCEDURE1.java" DB2I.PROCEDURE1 -...
11
by: steingold | last post by:
Hi All. Is it possible to define an external stored procedure to be executed not with the executing user privileges, but instead with the user who created the stored procedure privileges in db2...
0
by: Nova | last post by:
Hi, I created a Java UDF (PARAMETER STYLE JAVA) for DB2 9 Express-C. I finally does what I want it to do. However, after a few hundred calls to the UDF, it fails and raises an SQL error,...
0
by: ajitkathar | last post by:
In my SQLJ procedure , there is call to another stored procedure using a callable statement. But during excecution when .excute() happens . . the DB2 V7 database shuts down. Plz help. Follwing...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.