DB2 V8.1 64-bit client can't communicate with DB2 V8.1 64-bit database

I have a small test java program that makes a JDBC connection to the DB2 8.1 64-bit database from a client machine that has bothDB2 8.1 32-bit and DB2 8.1 64-bit clients. It works with the 32-bit client & does not work with the 64-bit client. I get the following error with DB2 8.1 64-bit client. ...

Updating DB2 instance to 64-bit (DB2 v8 FP2 on AIX 5L)

Folks:I have been trying to find a comprehensive document that lists all the issues involved and pros/cons of updating DB2 instance from 32-bit to 64-bit. I have found a document for version 7.2 and there are some things in there that would prevent us from going to 64-bit (JDBC support, Connectivity ...

DB2 Installation on 64 bit Linux

Is it possible to Install DB2 on 64 bit AMD Linux box with 32 bit DB2 software Image?Is there any work around?When I try to Install,I get the following message.An attempt to install DB2 for Linux 32-bit has failed. DB2 installation detected that the system is running Linux AMD64. Obtain DB2 for Linu ...

Error starting database after converting DB2 instance to 64 bit

I just gave this command to convert the instance to 64 bit:./db2iupdt -w 64 instance1the command executes successfully but when I try to start the db, I get this: db2startdb2start: relocation error: /opt/IBM/db2/V8.1/lib64/libdb2icuglue.so.1: symbol _ZTVN10__cxxabiv120__si_class_type_infoE, version ...

DB2 8.2 (64-bit) Setting for use with TSM (Tivoli Storage Manager)

I looking for document's or books that speak about DB2 configuration for use with TSM (Tivoli Storage Manager) all in 64-bit fashion, OS AIX 5.x ? Thanks in AdvancePID ...

unable to create DB2 V8.1 64-bit instance in AIX 5.3 ML 2

I am having problems creating a DB2 instance in my workstation. This is a new DB2 installation. The DB2 installer completes all steps but fails when creating the DB2 instance. The environment information is:AIX pSeries 5.3 ML 0264-BitDB2 V8.1 (have also tried creating instance after applying FP11 bu ...

BadImageFormatException with IBM.Data.DB2.dll on 64 bit windows

My project is a ASP.NET 2.0 application that connects to DB2 on mainframe using IBM DB2.NET Data Provider (IBM.Data.DB2.dll) Version=8.1.2.1. It works great when run on 32-bit windows.But when I recently hosted the application on 64 bit windows,the DB2 connection just failed with below error:BadImag ...

DB2 for windows 64 Bit

I am new to DB2, so this question may looks silly.I am using DB2 on windows 32 bit OS. I want to install it on Windows 64 bit OS. I want to know, is DB2 software different for 64 bit OS OR same 32 bit software can be installed on windows 64 bit OS ?I know in oracle, its different software for 32 bit ...

DB2 Windows 7 64 ODBC connection problem

Hello, can somebody help me with my problem?The subj. I've installed DB2 9.7 on Windows 7 64 and am trying to connect to it using ODBC. I also created BSTOREDB.When I'm trying to register it using DB2 Configuration Assistant as a local user data source an error Occurs (CCA3000C, reason code 73)If I ...

Restoring 32 bit DB2 Image onto 64 bit DB2 database

We are in the process of setting up new servers with 64bit DB2 database. Our current system are running on 32bit environment with 32bit DB2. So, can I restore the database on to the 64bit environment using a full backup image from 32bit environment. Please suggest! ...

DB2 7.2 64-bit for Windows

Does anyone know where I can download this client? I can not find it on theIBM site anymore.Thank you for your help,Dave Ritter ...

db2 32 bits and 64 bits instances on same server

I'm planning to upgrade some of the biggest db2 instances to 64 bits to overcome memory limitation issues but I wonder if I can have both 32 bits and 64 bits instances running on the same server. I assume you can but the tricky point will be TSM clients. I believe a TSM 32 bits client won't work on ...

Concurrent I/O on AIX and DB2 64 bits

Since we upgraded our db2 instance to 64 bits and enable CIO/DIO in all the Database filesystems noticed that we are having some performance degradation. Even more the Database backups that use to take only 2 hours is now taking between 5 and 6 hours. In our environment we are running AIX 5.4 and db ...

Is DB2 Everyplace 64-bit compatible?

I'm wondering if DB2 Everyplace is 64-bit compatible. I looked at the Device Platform Support page (http://www-306.ibm.com/software/data/db2/everyplace/devices91.html) and it's written "Windows 2000, 2003, and XP: any Intel Pentium architecture compatible Personal Computer". Does it include both 32 ...

buffer hit ratio with db2 8.2 and CIO/DIO

I'm runing db2 fixpak 12 64 bits on AIX 64 bits. We mounted the filesystem to enable the Concurrent I/O and Direct I/O. We did all this in order to avoid the double copying of data that results in additional CPU consumption and reduce the duplication of application data within the filesystem buffer ...

DB2 backup use TSM

after updating my db2 instance to 64 bit (db2iupdt -w 64) everything works fine except the backup using tsm. Executing a backup command, I get the message "SQL2062N An error occurred while accessing media "/db2data/db2inst/sqllib/adsm/libtsm.a". Reason code: "610"." whi ...

Can not find a V8.1 GA DB2 Linux CD...and IBM looks not distributing it any more...

I was trying to install a DB2 64-bit instance on a Linux Redhat (RHEL) 5.1 (2.6 kernel) 64-bit but the latest fixpak 16 installation requires the V8.1 GA installation CD.I do have (many) DB2 on AIX 64-bit CD but I can't find one for Linux.I recently asked IBM but still did have no answer==> Does ...

Shared memory error in Linux 64 bit

I had created the database in my 64 bit server. i have only one database in it. when connecting to it , i got the shared memory error[db2inst1@lnx6 ~]$[db2inst1@lnx6 ~]$ db2 connect to warehousSQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019[db2inst1@lnx6 ~]$I have RHEL 6 64 bit, ...

stored procedure error on 8.1 fp 18 ( 64 bit)

Hi, we just migrated from 32-bit 8.1 FP 15 db2 udb to 64-bit 8.1 FP 18 db2 udb on linux. I successfully restored the backup image of the 32-bit machine to the 64-bit machine, when I call a stored procedure on the new ( 64-bit) machine.. I get the error below... any ideas? thanks!!db2 "call db2i ...

Using DB2 V8 Admin client

All,We have two database systems, DB2 on Z/OS (32-bit) and DB2 on AIX (64 bit). We use DB2 Connect v7.2 to get DB2 on Z/OS.I had installed DB2 Admin Client v8 on my Dekstop and able to get to DB2 on AIX, but Admin client v8 prevents me from talking to DB2 Connect v7 due to difference in their versio ...

Automatic maintenance (AUTO_MAINT) = ON in DB2 Production Environment

Is it suggested to set the following Parameters ON in a DB2 Production Environment?Automatic maintenance (AUTO_MAINT) = ONAutomatic table maintenance (AUTO_TBL_MAINT) = ONAutomatic runstats (AUTO_RUNSTATS) = ONAutomatic reorganization (AUTO_REORG) = ONWe have a DB2 v8.2 64 bit edition running on Win ...

DB2 registry variables in migration from v8.2 to v9.7

We are currently migrating a DB2 database from v8.2 to v9.7 Source : DB2 v8.2 64 bit WorkGroup Unlimited Edition running on Windows 2003 x64 Enterprise EditionTarget : DB2 v9.7 64 bit Enterprise Edition running on Windows 2003 x64 Enterprise EditionOn my v8.2 database , I have the following DB2 regi ...

Seeking working linux setup for DB2 + NetSearch extender

Someone is using db2 with netsearch extender on Linux? I cant get it work after 3 days of trying. http://www.ibm.com/developerworks/forums/click.jspa?searchID=-1&messageID=14045758Are you running that combo? Please give me:Linux distro version, db2 version, 32/64 bit, output of ipcs -l and how m ...

DB2 9.7 installation ends Abruptly without any message

Currently I am installing db2 9.7 (64 bit) on RHEL 5.5 (64 bit),the prerequisites are all fine,I mean the packages needed for installation and all. But still the installation fails and ends abruptly without any conformation and files will not be created in the db2 instance owner folder.I am not able ...

db2 online incremental backup getting failed

My online incremental backup is getting failed today ,it throws the error that it has reached the maxfilop.So i have increased it to 61140 which is the maximum, then from OS level we have rhel, which had the maximum open connection/files as 1024 we increased it to 4096.And found in google as can be ...

SQL22209N .... unexpectec Java error

Any help on this please: Using DB2 v8.1- 64-bit trying to create catalog on existing tablespace:db2 create tools catalog toolsdb use existing tablespace tbsp32k0000 in database toolsdb;Error msg: SQL22209N The DB2 Administration Server encountered an unexpected Java error on host "". SQLST ...

Environment Setup Suggestions Requested

We wish to move to DB2 on Linux 64 bit. I have done some research and have come to this conclusion with regards to hardware and software.Box DetailsIntelItanium 2 processor based systems4 x 1 GHz CPU1 GB MemoryOperating System RedHat Linux/SuSe Linux Enterprise.Can someone please suggest more combin ...

Drop procedure takes looooong time

AIX 5.1, DB2 8.1, 64 bit (details below)We have serious performance problems when dropping procedures.Each drop takes 30 seconds or more. There is no difference depending on the amount of code in a procedure.We have approximately 800 stored procedures and each time we redeploy the system about 200 p ...

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 ...

Instance update problem..

I installed the last fixpack of DB2 Udb Ese 64-bit (FP17_MI00252.tar) but I can not update the instance with command:/opt/IBM/db2/V8.1/instance/db2iupdt db2inst1"In fact this is the error:DBI1250E Applications are still using instancedb2inst1.Explanation:There are applications that are still ru ...

QL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=8, TABLEID=2580

I am trying to customize a Siebel CRM Application (backend is DB2 on AIX 64)I am receiving below error in the application log files: "Error Error 1 2010-01-27 14:57:53 SQLError: sqlstate 23502: [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID ...

Instance update problem..

I installed the last fixpack of DB2 Udb Ese 64-bit (FP17_MI00252.tar) but I can not update the instance with command:/opt/IBM/db2/V8.1/instance/db2iupdt db2inst1"In fact this is the error:DBI1250E Applications are still using instancedb2inst1.Explanation:There are applications that are still running ...

QUEER install on Dell 64EMT dual core system.

System: Dell PowerEdge Dual Core 64 bit Intel cpu. OS: Centos 4.3 64. I am trying to install the latest image of db2 ec for 64 bit systems. It seems like it installs something, but incomplete. Here is the screen dump. ./db2_install Specify one or more of the following keywords,separated by spaces, t ...

catalog local db as remote for "Agent could not be startet error" (urgent)

I want to find ab better solution for following problem or being able to get a stable environment with this one.[b]Environment:[/b][i] Linux SLES9, 6GB RAM, 2 x 2GHz Opteron (but same problem on other linux systems) DB2 Express-C 64 bit 2.6kernel [/i][b]Error Message:[/b]codeCOM.ibm.db2.jdbc.DB2Exce ...

After beta---->GA, admin server confused, *thinks* it STARTED.

Ok. I made a mistake. I went fixpack route from beta to GA. But now, even if I install a complete new db in new dir with new instance, I can't get das to run.First, the system: 64 bit Linux/Centos, db2 9.1 64 bit image. System has been running the Viper beta image without problems.Second here is wha ...

SQL2043N when restoring from backup

I have db2 express-c 9.7 installed on OpenSuse 11.1 where I restored a database backup taken from a 8.x installation successfully. Now when I try to restore a new backup (created on the new installation) I get the error "SQL2043N Unable to start a child process or thread". I've tried to restore the ...

Instance doesn't show up in Control Center

I am using DB2 Express C (64 bit) on Windows 7.I created an instance using the command line tool. Command db2icrt MYINST. I can list the instance from the command line.But, it doesn't show up in the Control Center tool.Could someone please tell me why? ...

Errors restoring backup from 9.5 enterprise to 9.7 express c

Let me start this off by saying I am not a DB2 or database guru. I am a lab admin that makes his way though db2 and oracle installs to build my lab images. So please if you give any advice please be as specific and clear as possible, I AM NOT A db2 guru or even everyday user.I backedup a database ca ...

How To V9.5

I am seeking assistance with a move from DB2 8.1 to DB2 9.5.Our scenario at present is a Prod Region running on AIX DB2 8.1 FixPak 11 (32 bit) and a Dev Region running on Windows DB2 8.1 FixPak 11 (UDB) using Development Centre, Control Centre, etc. Data is accessed via an MS Access GUI using Runtim ...

Upgrade error (7.1.0.1 - 7.1.1.1)

Greetings. I write because i really don't know how to fix this. I have successfully installed RPM V7.1.1.1 update from V7.1.0.1 in other installation but here the update ends with the message: RPM v7.1.1.1 DATABASE CODE IS NOT MIGRATED SUCCESSFULLY. I have checked the logs and the only strange thing ...

64 Bit DB2 V7

Is it Possible to connect to 64 bit instance from 32 Bit Client in DB2 V7.x ...

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 ...

Db2 V7.2 fixpak levels for 64-bit AIX

I'm trying to determine which fixpak level would be best for the following scenario;AIX 5L OS - kernel running in 64-bit modeDb2 client install using V7.1.0.41 (fixpak 3) 32-bit mediaApplications using this Db2 client will not be utilizing 64-bit mode (i.e. this is a three-tier enviornment). Would i ...

How to check if DB2 is 32 or 64 bits ?

Can someone tell me how to determine if DB2 is 32 or 64 bits from within a shell script ? I know how to find out for the kernel (prtconf -k) but I have no idea for DB2.Platform: AIX 5.1 (both 32 and 64 bits)DB2: UDB EE 7.2 FP11 (both 32 and 64 bits) ...

Question about migration AIX from 5.1 32 bit to 5.2 64 bit on DB2 servers

Now the version of DB2 servers is V8.1 on AIX 5.1 32 bit in our environment. We have to upgrade AIX from 5.1 ML4 32 bit to 5.2 ML2 64 bit on DB2 servers. After doing the upgrade of AIX, should we do anything for DB2 servers or even DB2 clients ? Please give me advise and info resource. ...

DB2 v8 64-bit and TSM setup

RDBMS ==> DB2 UDB v8 ESEOS ==> AIX 5.xMost of our instances are 32-bit except a few odd ones and I was wondering if we require 64-bit API for TSM client for the 64-bit v8 instances. If anybody has any experience with this setup please provide your input or any link out there you are aware of.d ...

DB2 V8.1.4 aix 32-bit to 64-bit migration

Does anybody have any experience of migrating DB2 from 32-bit to 64-bit or is currently using DB2 v8 64-bit. We've got an OLTP database with approximately 6m transactions per week, which we believe will hit the limit on available bufferpool memory in the next year (hence the need to migrate). We hav ...

DB2 UDB 64-bit Vs 32-bit

When I look @ the URL http://www-306.ibm.com/software/data...is3264bit.htmlI see that there are no separate binaries for 32-bit and 64-bit solaris. This being the case, am I right to assume that a sun sparc system that has 32-bit DB2 UDB installed can be updated to use 64-bit with the same binary so ...

DB2 V.9 installation problem in EL 4 64 bit

i am trying to install db2 9 (64 bit) on Ent. Linux V 4. (64 bit). It is giving error.ERROR:The following library files could not be loaded by db2langdir in /shared/DB2_V_Client/db2/linuxamd64/install/../bin-> libstdc++.so.5-> libstdc++.so.5Check the following web site for the up-to-date syste ...

DB2 Install problems - AIX 64 Bit

DB2 V8.1AIX 5300-05-03I am trying to install DB2 on AIX machine but it fails when creating the instance. When I was running the setup, it asked me if I want to create the instance in 32 bit or 64 bit and I chose the 64 bit since the LPAR is 64 bit (both Kernel and Hardware). When it came to the step ...