DB2

trouble with C-written application and UDF on 64-bit Windows
We have some trouble with C-written application and UDF on 64-bit Windows ... Given the following production environment: - Windows 2003 Server on AMD64 - Microsoft C/C++ Compiler of Visual Studio 9.0 Express Edition (looks like 32-bit only) - DB2 V8.2 and multiple instances of DB2 V9.1 installed and running ... 24 Jul 2008 03:40

remove large number of rows using SQL only
I'm new to DB2. I want to remove large number of rows in a table without filling up the transaction log space. To this end we can repeatedly remove a fixed number of rows followed by commit. In Sybase, one can write a simple transact SQL using rowcount and while loop to. I saw several people suggesting simila... 28 Jul 2008 09:59

remove large number of rows
I'm DB2 newbie. I need to remove large number of rows from a table. I don't want to fill up the transaction log space. I have the below SQL that I feed to the db2 command to repeatly remove a fixed set of rows until there is no more to remove. However db2 complains about bad syntax. Can anybody advise how I... 23 Jul 2008 09:10

Control Center problems
Server: DB2 LUW 9.5 on Solaris 10 Client: DB2 Data Server Client 9.5 (= Control Center) on a Win XP SP2 Problems: (1) Tools --> Wizards --> "Backup Wizard" and press OK. In the next pop-up window I see all available systems correctly listed, but selecting any system won't display that syst... 24 Jul 2008 03:40

max sequence value --- how?
DB2 LUW 8.1 fixpak 14 Linux Red Hat AS I'm trying to get the maximum value of a sequence. Because of the way the sequence is used (on several tables comprising a fat view), its too expensive to do the usual select max(<col>) from <view> ; Is there some way for the system catalogs or some trick to get me the ... 24 Jul 2008 09:47

FETCH into sqlda structure
I am using DB2 UDB V8.2 on AIX. We recently added some VARCHAR fields into our database and I found an issue with how we are reading data when retrieving it into an sqlda structure using dynamic sql. Here is the issue: This particular table has several VARCHAR(256) fields. I set up a few records that spanned ... 4 Aug 2008 13:36

Treatment of SMALLINT in Java Program
Does a java program treat a DB2 column defined as SMALLINT any different than INT? In other words, if I changed a column from INT to SMALLINT, would that require any java coding change? ... 22 Jul 2008 15:46

cannot run db2imigr even if LIBPATH set
I have all the library already in path: $ ls -l /opt/IBM/db2/lib64 | grep libdb2o -r-xr-xr-x 1 bin bin 7757295 Jul 12 2006 libdb2osse.a* -r--r--r-- 1 bin bin 227313 Jul 12 2006 libdb2osse_db2.a $ env | grep LIBPATH LIBPATH=/opt/IBM/db2/lib64:/home/perfpol2/sqllib/lib64:/usr/... 22 Jul 2008 13:42

SSL support for natvie DB2 LUW (non-SQLJ/JDBC)
Hallo, Is SSL protocol in LUW only supported for IBM DB2 Driver for JDBC and SQLJ type 4 ? I want my NATIVE DB2 client to connect to DB2 server using SSL protocol (not using SQLJ/JDBC) Is this supported yet? If yes, can someone point me to a HOWTO I'm using Data Server 9.5 for Unix and Data Server Runtim... 25 Jul 2008 20:43

Preventing First Steps Launch Pad screen
Does anyone know how to prevent the First Steps Launch Pad screen from appearing after pushing out a remote installation of a Fix Pack? When DB2 PE is initially installed on our desktops it is installed so that the First Steps Launch Pad comes up after the installation, but since these are manually installed it i... 21 Jul 2008 12:01