DB2V8.1 (fp7a) on AIX 5.2.
These files are taking up ca. 100KB, and I'd like to prune them. Is
there a safe way to do this?
Thank you for your advice.

hi, i have a problem in importing data from .ixf files the dump was got
from AIX box and this dump is to be imported to win2003 box with
db2v7.2 fixpack8. i have just created a new db in the win2003 and this
dump is to be imported to the new db. IS the db2look.sql necessary for

I want to create a report in this format using DB2 sql  in EXPORT
Date :current date
Report Number# Generic number
              member_id             ssn         total

I have a table with some audit date and time columns. Problem is the
developer who stored the data left them as DECIMAL type instead of DATE
and TIME. Is there a way I can convert the DECIMAL type to DATE or
TIME? The column data is in the date form YYYYMMDD (i.e. 20060308 =

Is there anyway that I could preserve the comments when creating an SP
from Command Editor,so that when i import the SP in the development
center I can see them. The reason for such a request is that I am
moving SP's from the development environment to the production

at the moment i try to use the federated database feature (DB2/NT 8.2.3)
to use a remote host db2 (DB2 OS/390 7.1.2).
I am unsure what privileges are needed for the host db2 user.
A select on SYSIBM.SYSTABLES and on the tables where the data resides as

Hi - I would be grateful for advice regarding the following.
Via SPUFI, I am using an SQL member to generate further SQL Statements.
Unfortunately, the generating output SQL statements are longer than 80
bytes in length.

I have got DB2 UDB personal Edition 8 client is installed.
Iam executing some stored procedure.
I need to find out the version of java is DB2 is supporting.
How to find out

We are running DB2 8.2 (FP9) on Linux (64bit) with 64 bit instances and
we are reviewing the new features that we could activate on the 2.6
kernel.  We came up accross an interesting db2set parameter
DB2_LARGE_PAGE_MEM, but we don't exactly understand how it needs to be

I'm completely green to DB2, so please pardon my ignorance if this is
an extremely easy question.
I'm converting some queries in our application and it's choking on the
Group-By clause.

   does anyone know how to decode a compiled SQL statement (db2 z/os 7.1 -
skeleton cursor table)
   I'm trying to find all bound sql statements where the columns in a
'where' clause are of different sizes

Banging my head on this and it is probably  simple....
What is the cleanest way to get today's timestamp in a character string
of 14 without seperators YYYYMMDDHHMMSS?
Ie : 2006-02-28-10.53.37.230256

If I perform a select count(*) from tred.order_delivery query will it
internally perform a full table scan to determine the row count for the
following scenario
case 1: There is a primary key on a column

I am trying to create a db on db2 and when running the scripts, which
have been successfully ran before, I get the following error:
DB21034E  The command was processed as an SQL statement because it was
not a

I get the following when trying to restore a database on a new node
from a backup on another node:
RESTORE DB ocr3_p USE TSM OPTIONS "-fromnode dhu003p_db2" TAKEN AT
20060307022104 INTO ocr_o NEWLOGPATH /work/ocr_o/ocr_o/db2logs/NODE0000