Normally Google helps a lot with these simple questions, but now I
cannot get correct search words. So I try here:
I have db2 udb 8.1 fix pack 6, and it is on windows 2003 server.
- what is the maximum table space size? 64GB?

would it matter if I decided to make a primary key a string of numbers
vs actual numbers ? would it make any difference to DB2 in terms of  
efficiency ? why would you choose numeric over a string for a key that
does not need to be in numeric format ?

I need to uninstall DB2 Express on a W2K Server as the
evaluation period has expired to reclaim a fair chunk of
disk space.
The program was not in the list of the Windows

Greeting,
              Can anyone tell me the points to keep in mind while
migrating data from Sybase to DB2 especially in case of LOB data. I
know the books available on the IBM site, but if still someone can

Currently, I am using offline full backup for my working DB2 v8.1 for data
protection. The backup image will be dump to disk and then compressed by
bzip2.
However, the current DB size was over 3G and this exceeded the bzip2 limit

Is it possible to find out what tables are accessed by a compiled stored
procedure - if so, how?  I'm using DB2 LUW.
Thanks.

Hi, I have a DB2 database with database managed (DMS) tablespaces. One
of the tables that I have contains BLOB data. Recently I noticed that
75% of the tablespace for this table was being used up. So I deleted 50
records from the table freeing about 50 to 100 GB of space. But even

I have worked on this for hours and can't come up with a solution. Hope
someone can help me.
I have a table called TMBS_HMAUDIT_PARMS. this table contains data to
tell me how often a person is allowed to receive services for various

Hi, my question was not getting any attention because it moved to 2nd
page; so posting it again. Sorry for any inconvenience but I need to
get it resolved fast. Need your help!
****************************************************************************************************

What is the impact of using a nullable column vs a not nullable column
for partitioning a Union ALL View? I have a Union ALL View with ten
underlying tables unioned based on different values for a column
partition_id in these tables. Now, if I define this column as NOT NULL,

I want to have some of records in table to be undeleted?
how can i do that?
for instance, keep first 20 records of table undeleted or read only for
outside access

how do I write this SQL:
I would like to check the Main table for invalid rows. An invalid row
is: any row where the Start_date to stop_date range overlaps an invalid
date in the Code table. For example, Row#2 is invalid because the

one Windows administrator changed the servername (hostname) of one of
our database servers.
What changes do I have to to to get my databases connected?
The catalog statements have to be adjusted, I know.

Has anyone called a COBOL subroutine using COBOL CALL from a COBOL/DB2
stored procedure? What are the complexities associated and what system
setting might be required?
Is this approach strategically better compared to converting the COBOL

First time DB2 user here.
I have a backup from a unix box around 8.1.
I am trying to restore this backup on a windows box 8.2 (demo version)
I am not sure how the original backup was created but according to the