Hi Frenz,
I'm new to DB2 on which I have to work on client's machine.
My task is to create a job that constantly back up  some tables and
transfer the data into a file at regular intervals(once a week or so).

we are trying to copy a database from Version 9  to Version 8 server
(Linux) using 'db2move' and is failing on the tables that have COLBs
with "segmentation fault" error. Any suggestions ?
Thanks

Hello, all.
I can't figure out <subject> from documentation.
I had configured
    LOGARCHMETH1 = DISK:/bak/logs

Hi. I just installed db2 fixpak 4 for DB2 8.1 on AIX 5.3. The previous
filesets for db2 were at 8.1.1.24 level and the new ones are at
8.1.1.40 after the fixpak installation. I have rebooted the system and
did a db2stop/start but the db2level command still points to fixpak

What is the driving factor when making more columns indexable?
Should i see if i can modify existing indexes and merge new columns in
existing indexes or create a new index with new column?
regards,

I am a newbie when it comes to stored procs and i would like to learn
how to call a COBOL program from a stored procedure. The SP can either
be an DB2 SQL SP or an external COBOL/DB2 SP. I can use either
depending on which is more efficient.

Downloaded fixpak14 for DB2 UDB v8 , cksum shows 1191692111 , expteced
but.. when I unpack the file with zcat FP14_U810099.tar.Z | tar -xvf -
a lot of warnings occures..
tar: warning - file permissions have changed for

I have a script which works from the command line, but gives  the
following error message when run as a part of a email script. Any
suggestions as to a cause would be greatly appreciated.
SQL10007N Message "-1390" could not be retrieved.  Reason code: "3".

I created a function, but I don't know to call this function.
CREATE FUNCTION NAMEEMPLOYEE (DEPTO CHAR(3))
RETURNS TABLE (EMPID INTEGER, NAME VARCHAR(60), PHONE CHAR(8))
LANGUAGE SQL

We have logarchmeth1 set.  Also, we have a monitoring script that
checks the gap between any log files in the active log directory.  We
have just recently activated logarchmeth1 and what we have found is
that we have a large occurrance of gaps.  IBM has told us this is

How can i determine the codepage of a database from a CLI (or embedded
SQL) program ? Is there a catalog table that i can query for this
information ?
Thanks

Folks,
 Our client has a program that browses whole table from begining to end.
 The table has 1 million rows in it. REORGCHK does not show any problems.
 It has unique index defined on KEY0 column.

Here is the situation....
We have Primary Server A linked to Standby Server B via HADR.
Primary Server A has recently installed LOGARCHMETH1 to archive logs
and a 2nd homegrown script that compresses the archived logs once in

How to remove the transaction logs which are out of date in HADR
environment?
DB2 command PRUNE, it can only run on primary database but cannot run
on standby database. Because the database conection is not permitted

We have several instances & Databases on an AIX5.3 Server.
We need to change the hostname of the Server, will this break DB2?
The only reference to hostname I can "see" is in the Global registry
setting