I'm used to working with the old reliable Stored Procedure Builder in
Version 7. You created a project and made your database connection -
just like version 8.
Here's where I am running into confusion/issues:

Prio to installing FP3 for 8.1 on AIX 4.3 the command LIST
APPLICATIONS SHOW DETAIL used to display a timestamp in the "Status
Change Time" Column.  Since FP3, I get a "Not Collected".  As far as I
can tell, all switches are turned on now as before.  Any suggestions

I am unable to see the health monitor SQL table functions (e.g.:
SQLPROC.HEALTH_CONT_HI).  Have I missed a utility which registers the
functions?  DB2 8.1.3.132 WR21324.
Another point about the health monitor - when I get notification messages

We plan for 1 (big) server to host both a production and test database
for a system, and some other small db's. Databases to be put on a SAN.
But I don't understand the topics concerning installation and
administration. What can I do and what can't I do, when multiple

I installed DB2 8.1 Express on the WindowsXP, and when I begin to use it, I
found DB2 creates many new folders in C:\Documents and Settings. It creats
more and more folders every day. All new folders has name like: "db2admin",
"db2admin.MACHINENAME", "db2admin.MACHINENAME.001",

We are currently working on a project to migrate our Oracle database
to DB2. For migrating the data, we are using Oracle Select statement
which will write the data into a text file. Then we use Db2 Loader to
load the data into DB2. All the tables and columns are same in oracle

The db2 documentation explains the DB2_AWE rgisrty variable requires
three values to be supplied.
"The first parameter is the buffer pool id, the second parameter is
the size of memory you want to use in pages (Memory to use/page size),

Is DB2 Z/OS 8.1 getting CURRENT SCHEMA/QUALIFIER special register
finally? This has been a pain for dynamic applications such as java.
It's about time that DB2 Z/OS team finally close this asymmetry
between dynamic and static options and also close the gap with DB2 for

I'm trying to take an offline backup on Linux to an NFS mounted
filesystem. I have no trouble creating files or directories manually
in this filesystem. Here's the df -h for it:
Filesystem            Size  Used Avail Use% Mounted on

I have a test database that I have built in a 3 partition (and 3 node)
environment.  I have defined all the tables so they have the same
partition key.  The tables (7 of them) form a hierarchical
arrangement.  The data is all bogus, so I using the generate_unique

According to the CLI Guide and reference i can use the function
SqlDataSources() to get all aliases on the machine the application is
running.
But i'd like to get all node names and database names . Is that possible? I

I'm trying to install "DB2 workgroup Edition" from "Dummies Test
Engine DB2 UDB v7.1 evaluation copy" CD, which comes with DB2
fundamentals certification for Dummies for db2 certification exam 512.
The following errors occured during installation of db2...

I am trying to a get a trigger retrieved from Oracle to work on DB2
UDB 8.1. I am getting the following error when trying to create the
trigger. How would I resolve this?
create table dept (

I have spent the last 2-3 hours trying to find a way to just list the
constraints for a given table (this includes referential - foriegn
keys, not just check constraints).
I know how to create them, but can I see them, no way. Howz it done

I am trying to figure out what options I have for delimiting columns and
records in a flat file (ascii) that is to be loaded into db2.
I read through some of the documentation and it seems like there is a fixed
position method, but I'm not sure if thats the best bet for me.  The ...