| Thread | Last Post | Replies |
|
| Quiesce behavior | 20 Jun 2006 15:03 GMT | 1 |
When executing a quiesce immediate on a database does the command wait for all connections to be off the database before completing or does it act asynchronously? Lew
|
| Date function | 20 Jun 2006 10:33 GMT | 4 |
Which scalar function would be suitable for me to extract the date out of the following string: "060618154449" Thanks a lot for any advice.
|
| plz help | 20 Jun 2006 09:14 GMT | 4 |
would any body help me to create a database in utf codeset which supports japanese language and settings involved in them. thanks and regards situ
|
| how to make a chr(0) as the default value of one column? | 20 Jun 2006 08:23 GMT | 1 |
or any other special characters? I just want to find a way can be used in clp mode... thank you~~
|
| DB2 II for Linux AMD 64 bit | 20 Jun 2006 04:40 GMT | 3 |
Is there code for the DB2 Information Integration wrappers that runs on a Linux AMD 64 (kernel 2.6) machine. I can find the 32 bit Linux wrappers on passport advantage but there does not seem to be a 64 bit version.
|
| Rows on the fly and an outer join (use a lateral statement?) | 20 Jun 2006 01:26 GMT | 5 |
I have an employee table with two columns, one named login, the other named otherdata. I have a list of login values, some of which do not exist in the employee table.
|
| Loading several tables with a single LOAD command | 19 Jun 2006 19:44 GMT | 3 |
Is it possible to load more than 1 table using the LOAD utility? Cheers, San.
|
| event monitor for statements | 19 Jun 2006 17:39 GMT | 4 |
Can we create an event monitor for statements in a partitioned environment? CREATE EVENT MONITOR stmt_event FOR STATEMENTS WRITE TO FILE '/home/rajm/event' ON PARTITION 0 GLOBAL
|
| OLAP-Functions missing in DB2 Express-C? | 19 Jun 2006 09:06 GMT | 4 |
DB2 Express C (Fixpack 10, WR21362_15462) seems to be lacking some of the OLAP functions available in other editions, such as ROW_NUMBER, RANK and DENSE_RANK, but does provide sum(..) over (partition by ... range between ..). Is there a documented list of functions that are
|
| tools catalog | 18 Jun 2006 23:00 GMT | 2 |
Can anyone answers my questions. My server is AIX and is 5.2 and the db2 udb of V 8.1 Fixpak 9. What exactly is the tools catalog for? How it is uaseful in performing automatic runstats and reorgs?
|
| Help with query | 18 Jun 2006 04:54 GMT | 13 |
Thanks in advance for your help. Given the following table: CREATE TABLE T1 ( seq INTEGER NOT NULL,
|
| Error =?iso-8859-1?Q?=EDn?= DB2 6.1 | 17 Jun 2006 01:19 GMT | 8 |
I know DB2 6.1 is out of service. Please don't send any messages according to this point. An application without any documentation throws an error message: SQLCODE: -702
|
| upgrade DB2 WSE to ESE | 16 Jun 2006 17:14 GMT | 1 |
Is it possible to upgrade DB2 WSE to ESE for AIX directly? Or it need to uninstall WSE then install ESE? Thanks in advance, Laurence
|
| DB2 Reporting tools | 16 Jun 2006 16:02 GMT | 1 |
Our company has just bought an ERP system called Frontier that runs on an AS400 and uses DB2. Does anyone know of suitable reporting engine that work well with this platform e.g
|
| ADM7508E Database quiesce request has failed. The sqlcode is "-1044" | 16 Jun 2006 10:52 GMT | 2 |
hi, i have DB2 8.2 on linux and when i start a script to backup the DB , i receive this message on db2diag.log; ADM7508E Database quiesce request has failed. The sqlcode is "-1044" and there no explanation in IBM docs neither in the net.
|