Forum: IBM DB2

We have DB2 ESE version 8 sp2 under AIX. Most databases have about 1000 tables, and are rarely accessed much. If, on the AIX box, I do a "select...

i am using db2 udb v8.1 for windows 64 bit, based on the doc, i can create DMS to achieve high performance, to add the container, i can do file or...

Folks, Does DB2 support multiple charsets? In Oracle you can set NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET and declare a column as CHAR or...

Hi, I am trying to analize SMF record type 102 produced by DB2 audit trace class 2. When I look at a dump of the record I see the jobname that...

The volume column is of type decimal(31,6). select distinct volume from i_item_master VOLUME --------------------------------- 0.100000...

Anyone have anything I can use? Checked the SYSIBM tables and couldn't figure it out myself. Thanks.

Hello I'd like to load a native library in my linux java stored procedure using System.loadLibrary("mylib"); But the JVM didn't find the...

If I wanted to insert/update a field with data like this: "This is my data" How would I go about doing that? I have found that I can escape...

I heard DB2 32bit can only safely use up to 1.1 gigabytes of shared memory. I've summed up the ten DB2 memory components that utilize shared...

Does anyone know where I can download a trial copy of Information Integrator? (I was not successful in finding it on the IBM website) Thanks in...

Hi there, using a Java program on OS390 and DB2 version 7, we have the following problem: After creating a connection using...

hello, I don't know why but I have a little pproblem with some sql request. some time they need 0,9 seconde, some time 4 or 7 secondes some time...

Hi! We are using DB2 8.1 with FixPack 3 on Windows 2000 Server. We want to use stored procedures with our database, but when creating a simple...

Please ignore this. I am attempting to work out which news group is causing spam attacks on my email accounts. cio Derek.

I'm trying to debug a deadlock problem I'm having using DB2 7.2 and I'm a bit stumped. As part of my testing, I've turned statement batching...

Hi, I work for a company this is in the process of migrating existing ESQL code to CLI and I ran across problems with one of the applications that...

How can I run db2mscs to set instance profile on a special logical disk of three defined on a physikal disk. I tried this: ######################...

Hello All, What is the minimum version of DB2 that I would need to have a hot spare? I am concerned with ANY down time for the DB and need a way...

We are doing a comparison of DB2 and Oracle to replace our Informix database runing SAP. I have found some good white papers on why to select...

Please ignore cio Derek