I am comming along with all this Linus/DB2/scripting business...I am no
longer scared of it!! (LOL). But,
I need to create a .ksh script that does a REORGCHK and output only tables
recommended for reorg.

I'm using the following command to redirect restore from source
database AAA into target database BBB:
db2 restore db AAA from /DBBACKUP taken at 20080512100655 redirect
into BBB without rolling forward

Iam unable to load using a v9.1 Fixpak 0 client into a v8.1 Fixpak 16
database. I get the following error:
SQL3015N  An SQL error "-206" occurred during processing.
The message file gives a few more details:

Hi everyboidy.
My DBA is saying that this problem  can not be done by single query and it
should be done in a
COBOL programm.

I received a DVD worth of DB2 files of the structure:
TblName.SYSCNTL
TblName.SYSREC
I have no experience with DB2, but am pretty strong in SQL.  I see

how can I fix lock-waits during an online backup? Is an online backup
in DB2 V8.2 not realy online? I'm using DB2 V8.2 Fixpak 15 on Linux.
The command to perform the backup is: db2 backup db BPEDB online to /
var/tmp

I am writing a Java code for importing data to DB2. The following
lines are the code.
.....
CallableStatement stmt = _dbConnection.prepareCall("CALL

First, I'm not sure if I've directed this post to the correct groups
of COBOL and DB2. My apologies in that case.
Question:
I know that during precompilation and compilation of a cobolprogram

Just curios, given tables:
[lelle@53dbd181 share]$ db2 "create table A (c1 char(2) not null)"
DB20000I  The SQL command completed successfully.
[lelle@53dbd181 share]$ db2 "create table B (c1 char(2) not null)"

I will like to use DB2TOP for monitoring but have no idea how to install it
on my machines - both windows and linux.
My environment is DB2v8.1 fixpk 16 (windows and Linux) and a DB2v9.5 on a
linux server. I have looked for db2top in the

When upgrading DB2 LUW from 8.2 to 9.1 the following command is issued as
part of the upgrade:
db2 migrate database <db-name>
Does the migrate command make changes to every data and index page? Any

The following is my first embedded SQL program on Windows, which is
coded by C language.
/* sample.sqc */
#include <stdio.h>

I have been studying and working on databases for quite a time now. I
know quite a lot about databases. Now I have been assigned a project
where I have to build an application using the database. I know all
the work to be done with database. The cause of worry is front end of

Any Suggestions on the below scenario will be helpful to us.
# There are 10 tables in a schema “S1” and  I have to give select
privilege (Only read access) to a user on all the tables in the schema
“S1”.

Hi All;
I have a request for a report that will show a summary (count) of
timestamped events by the event type in 15 minute increments. I'd like
to do it in a single SQL statement. So my source data will resemble