| Thread | Last Post | Replies |
|
| db2_install error | 02 Aug 2006 15:45 GMT | 3 |
When I try to install the db I get this : # ./db2_install /home/oberon/movie/exp/disk1/db2/linux/install/../bin/db2langdir /usr/lib/libstdc++.so.5: version `CXXABI_1.2' not found (required b
|
| Syntax issue: URGENT | 02 Aug 2006 13:38 GMT | 6 |
I have a requirement where I need to return all the ids from Table1 if the column 'name' of Table1 is in (i.e. a substring of) the 'longname' column of Table2. How do I correct my SQL query as the below one is showing error:
|
| Tablespace reovery | 02 Aug 2006 02:59 GMT | 4 |
For tablespace level recovery of the db is the following strategy good enough? Sunday's Table - Full offline backup Mondays incremental to tape Monday's offline incremental backup +
|
| Express-C (Linux 32-bit) : CREATE DATABASE fails | 01 Aug 2006 23:44 GMT | 5 |
I get - db2inst1@dvorak /db2data $ db2 "create database DBTST001 automatic storage yes on /db2data/db2db dbpath on /db2data/db2db" SQL0805N Package "NULLID.SQLE2F0J 0X4141414141654557" was not found.
|
| Query tunning | 01 Aug 2006 20:30 GMT | 10 |
I have an MDC index on Big_A.Dt column. The following query always goes for a table scan. SELECT Key, Cd,
|
| How to start the DAS in Linux | 01 Aug 2006 19:16 GMT | 1 |
Hi Group, I did the DB2 ESE edition installation in Suse Linux using GUI wizard, the installation was perfect, able to successfully launch the control center. When tried to set up communication from my local machine to
|
| "Time waited for prefetch (ms)" very high | 01 Aug 2006 18:37 GMT | 3 |
Ive got a database approx 350 GB in which Im getting very high Time waited for prefetch. This is directly out of the snapshot for the db (these are for the entire database I assume as I pulled it out of get snapshot for all on {dbname})
|
| generate_unique primary key | 01 Aug 2006 15:53 GMT | 1 |
I am using generate_unique() to create my primary keys, in DB2 for windows. Any idea how to copy them to be inserted as foreign key data in different tables. I have tried copy/paste, I inserted them into a spreasheet and used the data that appeared in the columns, I timestamped ...
|
| PATHCH2="15" is ignored? | 01 Aug 2006 15:16 GMT | 3 |
v8.2.1, Windows 2000. I have comma as decimal separator - it is my locale's setting. It seems that instruction PATCH2="15"
|
| V9 client unable to connect to V7 server! | 01 Aug 2006 14:57 GMT | 2 |
I thought, clients were able to connect to servers not more than 2 release levels apart. But DB2 Express C V9 Win isn't able to connect to a V7 server (AIX). V8 server (Linux) is OK. Regards,
|
| How to expire DB2 backups in TSM ???? | 01 Aug 2006 14:40 GMT | 1 |
I am taking DB2 Online backups through TSM API daily. When i check the database configuration parameters , it shows me " Number of database backup verions to maintain"= 12. This is also shown when i check " db2 list history db " it showed me 12
|
| SQL30082N reason 36 | 01 Aug 2006 13:11 GMT | 1 |
We've got a nice running instance at 8.1FP7 (8.2), everything has been running very well on it. This morning,certain users get the following message 08001-[IBM][CLI Driver] SQL30082N Attempt to establish
|
| How to run LOAD or IMPORT from Java | 01 Aug 2006 09:40 GMT | 5 |
Is it possible to run the db2 utility to load or import rows from Java? I cannot find the correct command line structure. Thanks in advance, Alejandrina
|