| Thread | Last Post | Replies |
|
| Why run reorg after "alter table <name> alter column <colname> DROP NOT NULL"? | 29 Jun 2009 10:09 GMT | 3 |
According to the documentation, after running "DROP NOT NULL", a REORG
is required. This means, the "DROP NOT NULL" places the table status =
'X' (inactive).
In V9, after running "alter table <tabname> alter column <colname>
|
| Add members | 29 Jun 2009 08:03 GMT | 3 |
I want to join the group...
|
| FYI: "Enabling applications from Oracle to DB2 the easy way" | 29 Jun 2009 07:46 GMT | 4 |
Shameless self promotion... :-)
www.ibm.com/software/data/db2/9/labchats.html#32
 Signature
Serge Rielau
|
| CONNECT TO GROUP not working properly | 26 Jun 2009 13:56 GMT | 1 |
This is my env:
DB2: 8.2
OS: AIX 6.4
Here are the series of steps executed:
|
| Tranning db2 UDB v 9 in Latin america | 25 Jun 2009 21:07 GMT | 1 |
Please, I need a course of tranning of db2 UDB in Latin America,
Someone know anything about it?
Thanks.
Jorge Magallanes
|
| Need help in writing a complex SQL | 24 Jun 2009 08:35 GMT | 3 |
I want to select 4 records selected for every value in col1 order by
desc of datecol.. For example,
I have table like
col1 col2 datecol
|
| Installing DB2 on Debian 5 (Lenny) or other "unsupported" distro | 23 Jun 2009 10:46 GMT | 2 |
I have installed DB2 on two servers (Centos and Debian) according to
article:
http://www.aulix.com/articles/install-db2-on-debian
It works very fine on Centos 64 bit but backup/restore hangs on Debian
|
| Compatibility of LIKE predicate on DB2 V9.7 with Oracle. | 21 Jun 2009 17:52 GMT | 3 |
One of my expectation for DB2 V9.7 was the subject issue.
I think that DB2 still does not support ISO SQL2003 Feature F281, LIKE
enhancements.
My test was:
|
| select info an d the union operator | 19 Jun 2009 14:26 GMT | 1 |
Hello group,
we have the following SQL in our Cobolcode
EXEC SQL
SELECT
|
| db2 governor question | 18 Jun 2009 20:32 GMT | 1 |
I am interested to use db2 governor. i am interested to see which
connections, applications run queries etc. for more than 2 hours but
do not want to act on them. i do not want to force them off, reduce
their priority etc. i just want to see them in log.
|
| Table parititioning in 9.5 | 18 Jun 2009 16:35 GMT | 1 |
Suppose there is a table that is partitioned by day on a date column, and
there is another index for the PK (that is unique across all partitions) and
also some other non-unique indexes.
Are the indexes stored separately for each partition so that when the
|
| DB2 export in fixed length for NULL columns | 18 Jun 2009 01:19 GMT | 8 |
Here's is the scenario:
Table: TEST1
Columns:
C1 Char (5) Not Null
|
| Availability date of 9.7 | 17 Jun 2009 16:49 GMT | 1 |
Anyone know when 9.7 will be available on Passport Advantage?
|
| Converting string list to multiple rows | 17 Jun 2009 01:42 GMT | 9 |
I have a large list of data consisting of an id number, an effective date,
and several fixed length strings. Each string consists of a list of 12
values separated by spaces in 12 equally sized fields. I need to break
these strings up into monthly values and insert them into a ...
|
| UNIX db2 return codes | 16 Jun 2009 22:03 GMT | 2 |
I get that 0 designates success.
I also see the values 1,4, and 8 in my testing.
What are the return values that can be returned by the db2 command in
a UNIX environment?
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread