Apparently the maximum value of SECQTY for all tablespaces at a site I
am supporting is 131068 which is a pre version 6.2 maximum.  Any
insight would be appreciated.
Spufi alter and catalogue queries:

I just noticed that there are many SQL syntax with MODE DB2SQL in the help
document and many do not have this.  What is the different bewteen them ?
Thanks for any help
Tom

I was doing a FP8 (8.2) update on my db (Win XP 8.1 fp3) and the process
hung (3 hours - no activity) at the end.  The system was in la-la land
and the instance wouldn't start, so I removed the all the software hoping
that the instance would go with it.  No such luck

Apologize for posting this question....
Yes there were postings on update with join....
My question involves 4 table join... (hopefully qualifies as a new
question)

Hey gang,
I'm evaluating the CA ERWin product for an upcoming data warehousing
project.  I'm most excited about the reverse engineering aspect of
this system.

I have tested to import around 10,000,000 delimited flat file(about 1G)
into DB2 UDB 8.2 in AIX machine. I have 4 WAY and 8GB AIX box (no
application running this time. it's a development machine)
During the import, I didn't modify the bufferpool size and I had to

I have db2 8.1.5 (EE) on Windows 2003 Server
I have all monitor switches on
When I do :
dbn2 get snapshot for tables on dbname I get the expected output

I look at the table indexes of the system tables to see what kind of indexes
in UDB V8.
Here is my command:
SELECT DISTINCT INDEXTYPE FROM SYSCAT.INDEXES

When I run a DB2 command:
   i.e.: db2 list tablespaces show detail
and while this is running do: ps -ef | grep "db2 "
then I can see in the output the db2 command as: db2 list tablespaces show

I have a select statement that has more than 20 fields and result set
record length is more than 300 characters for each row. How do I modify
the sql such that the output is formatted for single page view, and
include new lines after the fields, as necessary. Certain fields should

I am doing a simple insert into a table and I would like the data to be
retrieved in the order it is inserted not by what appears to be
alphabetical order.
insert into mytbl values('c')

I'm currently working on a migration of a DB2 VM V7.2 database to DB2 UDB
Linux V8.2.
In the first stage the applications will stay on VM only the database will
be migrated.

As a refresher, a description of my problem is in the message body below.
I could not get answers to all of the questions that were asked below in a
previous thread, but here is what I found out:
1. Number of LOB's inserted per hour and average size

I wrote a job for unloading 80 table spaces into files by using the
sample from IBM handbook (with template and listfile option).
Finally, it works ;-)
The problem I encounter now is, that the punch files (loadcards)

Bonjour je cherche à afficher de count de tables identiques dans la forme
exemple
num_cli | nombre de poste | nombre de voiture
1              1                3