| Thread | Last Post | Replies |
|
| Database Marked Bad | 14 May 2007 13:14 GMT | 2 |
In an attempt to save disk space, I went in and gzipped all of the log files for my database running DB2 version 7.2 . This resulted in the database being marked bad because a log file was no longer found (I think).
|
| temporary tablespaces requirement size for creating indexes | 11 May 2007 07:42 GMT | 11 |
hi , all . I got a question about creating indexes in db2 . a table has 44236333 rows an index planed to be build include 2 field ( 6 byte )
|
| Recovering from a failed installation | 11 May 2007 07:28 GMT | 4 |
Wanting to look at V9, I attempted to install Db2 Express-C on a Suse Linux box I use as a sandbox. Since I was less that thorough when removing previous installations of V8 and V7, the installation failed creating the admin server. I now have a phantom instance that I can't ...
|
| Universal JDBC driver for DB2 | 11 May 2007 07:25 GMT | 1 |
Does anyone know the link of IBM's web site for the Universal JDBC driver for DB2? I just can't find it. Thanks,
|
| ADMIN_CMD and EXPORT | 11 May 2007 07:23 GMT | 1 |
Friends: The (v9) documentation for invoking LOAD via the ADMIN_CMD SP has this to say: "Since all load processes (and all DB2 server processes, in general)
|
| installing db2 udb v.8 on AIX | 10 May 2007 19:50 GMT | 2 |
I'm installing DB2 v8.1 on AIX but I need to modify the base directory of the product. In DB2 V.9 I can do ./db2_install -b /var/opt... but ¿Can I modify the base directory in DB2 v.8.1?
|
| DB2 Install in HA environment | 10 May 2007 19:19 GMT | 13 |
Is there someone on earth (or elsewhere ;-)) who knows how to install a DB2 V9.1 database engine in a High Availability cluster environment? I need help on that particular point. Best regards,
|
| ALTSEQ in logical files | 10 May 2007 14:40 GMT | 1 |
I have to use the QLA10025S translation table (SRTSEQ FOR LATIN 1 SHARED CCSID 00037) in order to equally process lower/upper cases and accentuated characters. I did add the ALTSEQ(QSYS/QLA10025S) keyword in my logical file.
|
| Consideration in chosing DMS container type | 10 May 2007 13:55 GMT | 4 |
What are the different considerations/guidelines in chosing raw device or file containers for DMS tablespaces? A link would be very helpful. Thanks,
|
| Tagging a table volatile causes performance penalties | 09 May 2007 16:42 GMT | 2 |
I'm trying to tune access times on a table which size might vary (from 0 to at least several thousand records). I've tried marking this table 'volatile' but it caused performance penalties on some operations:
|
| PL/SQL programming in DB2 | 09 May 2007 14:04 GMT | 4 |
Hi guys. i would like to develop functions and procedures to execute in db2 upon occurence of certain events within the stored data in db2. I understand Oracle databases have Procedural language extensions to Sql which makes this a lot easier. Is this also possible with db2.
|
| why do proC files to be binded to DB2 Database | 09 May 2007 09:23 GMT | 1 |
I was just thinking why do *bnd files to be binded with the DB2 Database. Thanks Pai
|
| IBM and Oracle - Let's Rrrrrrrrrrrrruuuuuuuuumbbbbbbbbbbleeeeeeee | 09 May 2007 00:05 GMT | 14 |
http://www.physorg.com/news97246418.html Officials at IBM are throwing verbal haymakers at Oracle as Big Blue touts its successes in the database market. The two database heavyweights alternated between offensive and defensive
|
| why DPF? | 08 May 2007 17:55 GMT | 10 |
Hi gurus, I know many of you are very senior DBAs and experts from IBM internal, so I really want to know your advice on this basic topic. "why dpf?" usually there's a rumor, em, I believe it's a rumor, that DPF can help
|
| EXPORT and Delete | 08 May 2007 17:45 GMT | 6 |
Friends: Let's say I'd like perform a delete, but before I delete, I'd like to export the target rows. I could use an export whose SELECT clause references the OLD TABLE of
|