I'm taking this exam on Wensday. There is one question I don't understand
from test (online) exam:
For which objects (Table, View, Index...) SQL source (DDL) is held in system
catalog and for which objects isn't?

How to differentiate between unique constraint and unique index? These
are very similar but I cannot differentiate them?
Could someone give me a hand?
Thanks in advance

db2 8.1.3 Windows.
I need to store some documents in db2 without using datalinks
manager.These can be MS word or PDF dcouments.Any suggestions how to
tackle this?

Hi, I experienced a problem while upgrading from DB2 UDB LUW Workgroup
edition 7.2 FixPak 10a to Workgroup Server edition 8.2 FixPak 12. The
install wizard said the upgrade was successful but none of the MIGRATE
commands worked due to authorization problems.

I have a question about DB2 ver 7.2
We are run out space and Network guys like to delete the old log files
of db2
Last week we had a problem in developer because they deleted the old

We are trying to connect from DataStage to a DB2 database on Z/OS. It
connects fine from the DataStage server, but when connecting from
DataStage client it gives the following error:
DSR.MetaGeta(GET.TABLES)(SQLConnect('USABCCP1','uspsxs')): BCI Error:

Hi, i am not really a db2 specialist, so i think i have a basic problem.
I have two tablespaces in one database which are a generated by SAP Business
One. The tablespaces are representing different companies. Here, on is for
testing the other for productive use.

For a given invoice/receipt I have the line items sold and possibly
multiple receipt lines: cash, check and credit card(s). The business
rule I wish to enforce is that the sum of the amounts of line items is
equal to the sum of the amounts of receipts. Where and how is such a

     I am doing a redirected restore from an offline backup file. All
the paths and files have been created and I managed to do all the set
tablespaces commands. But  once I do the "restore db <dbname> continue"
it gives me the following error

I have Db2 9 installed in Windows. Am trying to create a table with the
following DDL
CREATE TABLE DB2N.T_CO (
      a1    VARCHAR(100) NOT NULL,

I have been told to set the performance benchmarks for all the db2
databases hosted on all servers. I have no clue as to how to approach
this problem.
Can this be done theoritically through extrapolation techniques.One

I have a table creation script that generated by ERWin. An index name
is too long and has been truncated as "XPKsp_prj_stk_ord_". Now I want
to drop and recreate it as another name. I got error when I drop it:
SQL0204N  "SPARADM.XPKsp_prj_stk_ord_" is an undefined name.

       I have a small Query regarding remote connection.
C:\Documents and Settings\Administrator>db2 attach to mynode1
SQL30081N A communication error has been detected. Communication
protocol

How does this work?
I have one database SBO_DB (SAP BusinessOne)
I want to copy tablespace TS_SEW_ACCESS_DEMO to TS_TEST2.
The directory of the database is: F:\DB2\NODE0000\SQL00002

I managed to get the below function running:
CREATE FUNCTION MYSCHEMA.SEQLOAD_ID()
   RETURNS VARCHAR(20)
  F1: BEGIN ATOMIC