DAS failed after update FP2 (DB2/64 8.1, AIX/5.2)

I have a problem with the DAS on DB2/64 8.1 (FP2), AIX/5.2After I applied the service pack the DAS quit working. At least that's whenI noticed it.I dropped the DAS "dasdrop" and tried to recreate but it still does notwork.The only thing that is not standard on the installation is that I ha ...

DAS failed after update FP2 (DB2/8.1, AIX/5.2)

I have a problem with the DAS on DB2/8.1(FP2), AIX/5.2After I applied the service pack the DAS quit working. At least that's whenI noticed it.I dropped the DAS "dasdrop" and tried to recreate but it still does notwork. dascrt -u db2_das YOU HAVE NEW MAILexec(): 0509-036 Cannot load program /export/h ...

/usr/opt/db2_08_01/lib64/libdb2osse.a

DB2 8.2AIX 5.3WHEN ATTEMPTING TO RECRREATE THE DAS, I GET:/usr/opt/db2_08_01/instance #./dascrt -u db2saDBI1765W A non-existing user ID, db2ert, has been detected from the registry. Explanation: The registry is containing a non-existing user ID. This can be caused by just removing the instance user ...

dasupdt cannot find shr.o in libdb2dasapi.a

****************************DB2 v8.1.6 on AIX 5.2$ db2levelDB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL08016"with level identifier "02070106".Informational tokens are "DB2 v8.1.1.56", "s040616", "U497635", ...

Problem when execute command db2level

We're using DB2 v8.1.1.88, FixPax 9OS: AIX 5.3We are having problem when execute db2level command from DB2 Commandline, it gives us these below error messages :$ db2levelexec(): 0509-036 Cannot load program db2level because of the followingerrors:0509-150 Dependent module /usr/opt/db2_08_01/lib64/li ...

das / db2iset

AIX 5.3DB2 8.2/usr/opt/db2_08_01/instance #./dascrt -u db2saDBI1765W A non-existing user ID, db2ert, has been detected from the registry. Explanation: The registry is containing a non-existing user ID. This can be caused by just removing the instance user ID without first dropping the instance. This ...

Cannot load program

AIX 5.3DB2 8.2 (64 bit instance)> ./tf70serverexec(): 0509-036 Cannot load program ./tf70server because of the following errors:0509-022 Cannot load module /usr/opt/db2_08_01/lib64/libdb2.a(shr.o).0509-150 Dependent module /usr/opt/db2_08_01/lib64/libdb2trcapi.a(shr.o) could not be loaded.0509-15 ...

32bit to 64bit instance

i have convert by database instance from 32bit to 64bitwhich is done successfully db2start works fineafter that any thing it gives errordb2levelexec(): 0509-036 Cannot load program db2level because of the following errors:0509-150 Dependent module /usr/opt/db2_08_01/lib/libdb2osse.a(shr_64.o) could ...

create tools catalog db error!

I am getting the error when i issue create tools catalog db thorugh the db2 administrator server userid and i got the below error messages. can please anyone help with this issues./home/db2das>db2 create tools catalog cc use existing database newdbexec(): 0509-036 Cannot load program db2 because ...

Cannot load module

I'm having these errors for a while, and could not find a solution for this...2011-05-25-05.42.10.932376-300 E2721564A704 LEVEL: Error (OS)PID : 1789958 TID : 1 PROC : db2fmp (2789534) 0INSTANCE: db2inst1 NODE : 000FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:130CALLED : OS, -, dlo ...

Error: Cannot load program bash

I have downloaded the bash package from ibm site.I unpacked it and then executed bash on command prompt. It responded with following error:exec(): 0509-036 Cannot load program bash because of the following errors:0509-150 Dependent module /usr/local/lib/libintl.a(libintl.so.3) could not be loaded.05 ...

Installed some RPMs from the Toolbox cd and have some pre-reqs issues

I'm not sure if you can help, or if this is the correct place for this but here goes.I've installed some rpms on AIX5.3, 5300-10-03-1013 and have some issues with pre-reqs for emacs as can be seen with the following, has anyone here seen this before and know of how to fix this please./opt/freeware/b ...

Error: Cannot load program bash

I downloaded the bash from IBM site. I unzipped the packagethen I executed bash on command prompt.It responded with the following error:exec(): 0509-036 Cannot load program bash because of the following errors:0509-150 Dependent module /usr/local/lib/libintl.a(libintl.so.3) could not be loaded.0509- ...

Oracle 8.1.5 & PHP

I am getting the following error when I try to run php:exec(): 0509-036 Cannot load program php because of the following errors:0509-150 Dependent module /home/oracle/product/8.1.5/lib/libclntsh.a(shr.o) could not be loaded.0509-152 Member shr.o is not found in archivelibclntsh.a exists in /home/ora ...

help ! Error after install Oracle Database patch 9.2.0.5 on AIX

My database version on AIX server is 9.2.0.1, and I installed the 9.2.0.5 patch to update it .But when i run the catpatch.sql, the out of process memory exception always occured even if i change the java_pool_size and share_pool_size both to 200M in init.ora file.and when i run bi_checkconfig.sh to ...

Oracle RAC 10.2.0.1 install on AIX 5.3 fails on root.sh

I am getting the following message when running root.sh during CRS 10.2.0.1 install on AIX 5.3 ML04: ./root.shWARNING: directory '/oracle/product/10.2.0' is not owned by rootWARNING: directory '/oracle/product' is not owned by rootWARNING: directory '/oracle' is not owned by rootChecking to see if O ...

unable to start the db2 using db2start

db2inst8 /home/db2inst8>db2startexec(): 0509-036 Cannot load program /home/db2inst8/sqllib/adm/db2star2 because of the following errors:0509-130 Symbol resolution failed for db2star2 because:0509-136 Symbol sqleInitAppTable__FP8sqlekrcb (number 31) is not exported fromdependent module /usr/opt/db ...

DB2 V8 Licensing Issues

We just finished installing V8 Fixpak 4 on AIX 5.1 and we updated the licnece and it looks like this. Product Name = "DB2 Enterprise Server Edition" Product Password = "DB2ESE" Version Information = "8.1" Expiry Date = "Permanent" Registered Connect User Polic ...

DB2 Case Statment

Running DB2 8.1 fixpack 5Windows 2003 Enterprise ServerTrying to run a case statmentGetting Error: SQL0104N An unexpected token "END-OF-STATEMENT" was found following "END". Expected tokens may include: "JOIN <joined_table> ". I am trying to run the following case ...

Accessing DB2/UDB 8.1 from TOMCAT 5 on XP

I am learning to use the above components and I am using a sample servlet.The code is as follows:String url = "jdbc:db2://localhost:6789/tcasedb"; String userid = "db2admin";String passwd = "db2admin";String dbDriver = ("com.ibm.db2.jcc.DB2Driver");Class.forNa ...

Problem in connecting to DB2 V8.1 on Linux

I am trying to connect to DB2 V 8.1 on Red Hat Linux V5 from WebSphere Application Server V6 on Windows Server 2003.The problem that i am facing is that its not able to opent the socket on the port to communicate with the was and the db2.here is the error i get:[11/09/07 10:42:22:156 CEST] 00000043 ...

exec(): 0509-036 Cannot load program db2start

im using aix 5300-06 with db2 8.2 fixpact 9. when i do a db2start below are the error, is thier a problem with me aix installation or with db2? hope someone can help me to resolve this problem. im new with db2.$ db2startexec(): 0509-036 Cannot load program db2start because of the following errors:05 ...

Test Connection Fails-DB2/WAS-Null userid error

GuysJDBC resource gets configured from command line where all DS connection attributes are given correctly.I get a message saying " JDBC Resource Configuration Completed " .I open admin console of WAS(7.0beta) & try to test the connection for the newly created datasource.I get followin ...

Batch Aborted with the db2 error

We are using the server -OS - AIX 5.2 and DB2levelV81.FP16.Application team is running the batchjob which loads data from one db to the other in the same server. While running the job,the batch job has aborted with the following reasons:SQL0444N Routine "SQLTABLES"(specifc name"Tables ...

Sqlcode=-440, Sqlstate=42884, Driver=3.50.152

We have an in house application that I am trying to deploy using websphere 6.1 and DB2 9.5...I am not the programmer of the application however, I am trying to get it to work on the afrorementioned platforms. We currently have the same exact application deployed on Sun App Server 9.1 with SQL server ...

Communication between JAVA and DB2 HowTo?

Hello, i am new to Java and DB2. If my posting is just too stupid, please dont laugh that loud.Situation:There is my PC with a JAVA-applicationThere is another PC running a DB2.Both PCs stand in different buildings, connected via VPN.An IBM DB2 client runs on my PC.The JAVA-application ist connected ...

Can anybody help me on DB2 V9.1 FP5 on AIX 5.3

I am running DB2 V9.1 FP 5 on AIX 5.3 on a P-series server.The server refused to accept telnet sessions and it was logging off users who tried to connect to telnet.While checking the DB2 error logs in db2diag.log I found out the following... ************************************************** ****** ...

problem for reading DB2 DBCLOB data type

I have a simple jdbc client reading different data types for DB2 unicode database. I am getting this error.Here is my code..java.util.Properties prop = new java.util.Properties();prop.put("user", username);prop.put("password", password);String sql = "select * from data_types ...

com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-401, SQLSTATE=42818, SQLERRMC==,

i want to select the roles for a product. i am getting following exception ..and what could be reason.Please any help will be appreciatedcom.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [/AdminRoleProduct.jsp]: Initialization successful.[10/13/09 12:30:22:695 IST] 0000003e application ...

SQL CODE 4499 on DB2 9.7 Patch 1

I am working on DB2 9.7 Patch 1. I am running an SQL XML which fetches aroung 15 columns. One of these columns is of type CLOB. After fetching few records JBOSS gives the following error**ERROR**Message: jcct41037911961http://3.50.152 Client disconnect exception encountered: jcct4203011211http://3.5 ...

Db2 error code -4499

I am currently working on DB2 9.7 database which is installed on the Linux OS. I tried to run a query on the database using JDBC and I am getting the following errorcom.ibm.db2.jcc.b.gm: [jcc][t4][2030][11211][3.50.152] A communication error occurred during operations on the connection's underlying ...

DB2 connection from code

So i've been trying to connect in to DB2 from code for some time now without having any luck. Im using powershell, but, its not really any different than any other .NET method.So i located and extracted the ODBC/CLI package (v9fp9_winx64_db2driver_for_odbc_cli.zip) and ran the db2oreg1 -i to install ...

Getting error while executing any db2 command

Please help me in getting out of this....We are presently working on version 8.1 fp 12 and planning to migrate to version 9.5.I have installed version 9.5 yesterday and after that I am facing a problem...after issuing any db2 command I am getting below error:DB21015E The Command Line Processor backe ...

0509-036 Cannot load program db2star2 because of the following errors

After upgrading the DB2 v8.1 with fix pack FP11 and try to start i am getting this error pls help me.bash-2.05b$ db2startexec(): 0509-036 Cannot load program db2star2 because of the following errors:0509-130 Symbol resolution failed for db2star2 because:0509-136 Symbol sqle_calc_krcbheap_bytes__FP9s ...

WAS V6.1 connection problem with DB2 V8.1 on Linux Platform

I am trying to connect to DB2 V 8.1 on Red Hat Linux V5 from WebSphere Application Server V6 on Windows Server 2003.The problem that i am facing is that its not able to opent the socket on the server port to communicate Websphere with the db2.here is the error i get:11/09/07 10:42:22:156 CEST 000000 ...

0509-022 Cannot load module /home/db2tiemp/sqllib/function/asnadmsp.

I work with Q-Replication in DB2 UDB 8.1 Fixpak 12 in 64-bit and for creation of Replication queue map y use the replication center and the document named:"Upgrading Replication Center to display and test MQ queue managers and queues"The Operatin System is AIX 5.3 (64-bit)But in DB2 log appear many ...

Problem in loading audit data from .del files into tables in DB2 9.5

There are certain entries in .del files where a single record is stored(broken) into two lines.When we load this .del file into a table using create table queries as per documented in http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/t0011540.htmfor a sing ...

Problem while loading CLOB data using db2 load.

I'm facing a problem while trying to load CLOB data using "db2 load" from a file.I'm giving the command as db2 "load from SET_Data of del modified by chardel# delprioritychar messages db2LoadReport.msg REPLACE INTO DM_CLOBSET_DATA NONRECOVERABLE" I'm getting the warnings in the msg file as SQL3115W ...

(OS) Errors in db2diag.log / DB2 v8.2

My DB2 environment is: AIX 5.3 DB21085I Instance "db2tiemp" uses "64" bits and DB2 code release "SQL08025"with level identifier "03060106".Informational tokens are "DB2 v8.1.1.112", "s060429", "U807381", and FixPak"12".Product is installed at "/usr/opt/db2_08_01".And I receiving the next message in ...

Connecting Universal DB2 9.5.0.808 to Sun Application Server 9.1.02

I am trying to connect my application server to my DB2 databse. I have copied the db2jcc.jar to my C:\Sun\AppServer\lib directory. I have used the following configuration:Data Sourcename = com.ibm.db2.jcc.DB2DataSourceResource Type = javax.sql.connectionpooldatasourceUnder Properties I have entered ...

db2 won't start ..

.. after upgarding AIX from 5.2 TL10 to 5.3 TL8. > db2levelDB21085I Instance "tec" uses "32" bits and DB2 code release "SQL08012" withlevel identifier "02030106".Informational tokens are "DB2 v8.1.1.16", "s030508", "U486566", and FixPak "2".> oslevel -r5300-08> db2startexec(): 0509-036 Cann ...

How to select a column of CLOB data type from a table in DB2.

I have a resultset with following properties.ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLYWhen I use the select query on a CLOB data type column from a table,I get the following error.select columnName from schemaName.tableNamecom.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-270, SQLSTATE= ...

Problem with fixpack 6 DB2 Connect 9.1

I installed DB2 Connect 9.1 in AIX 6.1 64 bits and it worked fine. Then I installed fix pack 6 and when I try to start the manager with the db2start command I get the following error:exec(): 0509-036 Cannot load program db2star2 because of the following errors:0509-130 Symbol resolution failed for d ...

Issue on Db2 9.7 PE,Create database, Cannot run SQL stmt using java jdbc

Steps1. This worked in Db2 9.5 Personal edition. Not sure what has changed in Db2 9.7 Personal edition.2. I installed Db2 9.7 using my Windows XP administrator account, (I did create db2admin account, did not enable OS security)3. After installation, I created a simple database using Control Center. ...

DB2 9.5 jdbc

I am facing a problem when trying to execute a sql statement, like "SELECT SOMETHING1, SOMETHING2 FROM SOMETABLE" via jdbc. DB2 version is 9.5, i'm having java6 se and within a java ide i'm getting an error like the one above :com.ibm.db2.jcc.b.nm: DB2 SQL Error: SQLCODE=-7, SQLSTATE=42601, SQLERRMC ...

read DB2 unicode dbclob with JDBC

I have a table that has DBCLOB data type. The data in that column seems to be saved as uncode, instead of unicode big endian. When I try to read it by using getObject, getBytes, getCharacterStream, I get the following error.com.ibm.db2.jcc.b.SqlException: jcc103712036http://3.50.152 Exception occurr ...

DB2 - Tomcat A communication error occurred

When Tomcat tries to create a DB2 connection it gets the follwoing error:Caused by: com.ibm.db2.jcc.b.gm: jcct4203011211http://3.50.152 A communication error occurred during operations on the connection's underlying socket, socket input stream, or socket output stream. Error location: Reply.fill(). ...

DB2 SQL Error

Can someone help me on following error?I have read the documentation on infocenter for SQLCODE=-1476 but I don't understand the meaning of SQLERRMC=-911.<hr />Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4228, SQLSTATE=null2008Aug04-12:13:58 ERROR ...

Have you ever seen "com.ibm.db2.jcc.b.SqlException: NULLID.SYSSN300" ?

I am trying to migrate a Web-Application from WAS4.0 to WAS6.0 This Web-App, deployed in WAS4.0, used a driver (db2java.zip) to communicate with a DB2 V7.2 database on Windows NT => It works fine. In WAS6.0, i configure a DataSource using the "DB2 Universal JDBC Driver" (db2jcc.jar, db2jcc_licens ...

Connectiong Universal DB2 9.5.0.808 to Sun Application Server 9.1.02

I am trying to connect my application server to my DB2 databse. I have copied the db2jcc.jar to my C:\Sun\AppServer\lib directory. I have used the following configuration:Data Sourcename = com.ibm.db2.jcc.DB2DataSourceResource Type = javax.sql.connectionpooldatasourceUnder Properties I have entered ...