| Thread | Last Post | Replies |
|
| Retrieving get_db_config information in SQL statement. | 02 Mar 2005 16:28 GMT | 2 |
Using UDB 8.2 there is a procedure called get_db_config. What I would like to do is to retrieve a certain value from the DB Config in a SQL Statement. To give some more detail, I created a view which will show me my complete bufferpool configuration. However, now with V8.2 I would ...
|
| How to reterive the last 5 records in a table? | 02 Mar 2005 16:15 GMT | 20 |
I have a table which contains number of rows. I want to fetch the last 5 records from the table. I know for the first 'n' records we can use FETCH FIRST n ROWS ONLY command. But i want to fetch last 5 records. Can any one help in this...
|
| Migrating DB2 v7 to v8 on z/OS | 02 Mar 2005 14:01 GMT | 1 |
Can anyone point me to documentation on the "gotchas" of migrating v7 to v8? Thanks.
|
| Help in gathering deadlock information | 01 Mar 2005 22:44 GMT | 2 |
I'm trying to assist in analyzing a deadlock situation that sometimes occurs on a UDB/AIX system. We have several java applications that connect via jdbc contending for a workflow table on the server. Under certain conditions this leads to some threads deadlocking, and a resulting ...
|
| Replication with UDB v8 | 01 Mar 2005 16:44 GMT | 2 |
Regarding a new replication process using two Windows 2000 servers at 5.00.2195, one machine with SP4 and the other SP3, and both running WSE 8.1.5., I am requesting assistance. My dilemma--It appears that my replication scenario is running without any errors, BUT it is not
|
| Multiple DB2 versions on Windows? | 01 Mar 2005 16:22 GMT | 2 |
I was talking to a colleague the other day and mentioned that I was thinking of installing DB2 (LUW) V8.1 FP8 on the same Windows XP machine that currently holds DB2 V7.2 FP 9. He told me that it is not possible to put two different versions of DB2 (LUW) on the same Windows ...
|
| Replication with v8 UDB | 01 Mar 2005 15:04 GMT | 1 |
In setting up a replication scenario to update tables between two Windows 2000 servers at 5.00.2195, one machine with SP4 and the other SP3, and both running WSE 8.1.5, I am getting the following errors (copied from the .trc file):
|
| Question on a table reorg with clustering index. | 01 Mar 2005 12:28 GMT | 3 |
Running DB2 version 8.1.1 on AIX 5.1.1 The table (employee) is being reorged and has a clustering index (empid). Is there any different between these two commands?
|
| Help needed..... | 01 Mar 2005 05:06 GMT | 8 |
I have created servlet program using Netbeans.I have also written the JDBC connectivity.But FileNotFoundException is arising.Can someone help me?
|
| Design advice | 01 Mar 2005 03:04 GMT | 3 |
I just got stuck with cleaning up a mess of records for a group I belong to - circa 80k memebers - that are being kept on a variety of spreadsheets and Access databases by a bunch of different people. Hopeless mess, it is. I happen to have a DB2 license I can use so
|