Database Forum - DB2 Topics

Thread preview

Thread	Last Post	Replies

changing directory for data file	13 Jan 2006 14:10 GMT	9
when installing db2, it only asks for installation directory and does not ask where it is going to store data files. how can i change the default directory after installation.
How to query the DB2 z/OS V7 dictionary for indexes?	13 Jan 2006 10:35 GMT	1
Hi, i've tried to query the dictionary for indexes on a table as follows: SELECT KEYS.COLNAME, KEYS.COLNO, KEYS.COLSEQ, KEYS.ORDERING FROM SYSIBM.SYSKEYS KEYS, SYSIBM.SYSINDEXES IDXS
Retrieving Object ID's	13 Jan 2006 03:14 GMT	3
Do we have the concept of ID's assigned to objects like tables, indexes, view etc. I mean in sybase we have a function to select the object ID's. Do we have this concept in DB2. If yes, how can we do it?
MERGE performance help DB2 UDB v8.1.9	13 Jan 2006 02:12 GMT	3
We have a very poorly performing MERGE statement (an hour or more on tables of ~10000 and ~100000). This may require building temporary tables with appropriate indexes, but I thought I would ask your collective opinion. Would building a comprehensive index on
Removing Punctuations	13 Jan 2006 02:10 GMT	2
I want to remove all the punctuations in an address column if any: Select translate(ADDR,' ',':;.,!?-') from Table; I am able to remove all except for single quote ('). Can you please please suggest a way us Db2- sql
Stored procedure	12 Jan 2006 21:27 GMT	3
How to extract only the stored procedures which has been already created in the database. db2look has an option to extract only the tables but not for procedures,triggers, udfs. However, db2look extracts evrerything
Fedora Core 4	12 Jan 2006 19:08 GMT	4
Can we install the admin client for DB2 7.2 on Fedora Core 4? Thanks, PW
Right Align the character field Value	12 Jan 2006 17:21 GMT	5
column nme: TEMP Datatype: CHAR length: 6 the value we are getting is TEMP
containers in the same FS	12 Jan 2006 16:34 GMT	1
IBM recommends to place each ts container on a different physical disk. What about the impacts if all containers (DMS) are in the same FS (supported by multiple disks) ? Does DB2 preallocate doing // IO, so we could assume to have, for 2
Online Backup versus Offline Backup ?? What's the point ??	12 Jan 2006 16:22 GMT	4
I have recently begun to migrate our DB2 UDB v7.2 enterprise databases up to DB2 UDB v8.2. One question I can't seem to understand is why would I want to run an offline backup for a database now that the online backup includes the
Load Flatfile in UDB (Server) from z/OS-Mainframe	12 Jan 2006 16:14 GMT	1
Hello out there! Is there anybody who can help me? I generated some datas in three flatfiles on our z/OS-Mainframe. But these datas should be used in a UDB-database on a server.
Timestamp problem after upgrade DB2 ODBC Client from 7.x to 8.x	12 Jan 2006 10:17 GMT	3
After upgrade ODBC Client from version 7.2 to 8.1 (FixPack 10) a have problem with tables where primary key is set to timestamp filed. In version 7.2 TIMESTAMP was mapped in MS Access as CHAR(26). Everything worked OK.
client instance and server instance	11 Jan 2006 22:30 GMT	7
I have a question... I have a bunch of instances... Is there any way to tell which instance is client instance? Your help is very appreciated.
Dropping tables	11 Jan 2006 22:26 GMT	7
I have to drop large numbers of test tables (> 200) fairly often. This operation seems to be very slow. Is there some way to speed up the process of dropping tables?
SQL statement parsing	11 Jan 2006 22:11 GMT	1
In case the SQL statement is not written properly, we sometimes get strange messages. The 2 following statements are simple inversion between order by and group by clause. We get an "advice" about expected from or from_clause, why ?