| Thread | Last Post | Replies |
|
| MQT and too small transaction log size | 06 Feb 2008 14:40 GMT | 3 |
We tried to use MQT in our environment, but with the biggest MQT
we always run into this problem:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
|
| DB2 Catalog Locks | 05 Feb 2008 21:01 GMT | 1 |
I am having some recent problems with locking in DB2. Perhaps someone
can shed some light and perhaps provide a better alternative to the
following scenarious. Thanks.
1. While running Full ONLINE backup of DPF system, Informatica
|
| declare global temp table and package cache conciderations | 05 Feb 2008 19:34 GMT | 3 |
Any thoughts on the following scenario anyone?
During a performance test I discovered that the application asked one
specific query extremely often. It turned out that this particular
query where asked 25/50/100 or 200 times from a "htmlpage", dependent
|
| SQL function for HEX input | 05 Feb 2008 11:31 GMT | 1 |
I am looking for an SQL function which does exactly the same like the
x'<hex-string>' in an insert.
Background:
I want to "translate" a hexadecimal string (not number) with a length
|
| Administration server and LDAP | 05 Feb 2008 00:16 GMT | 5 |
We have some DB2 databases (v. 8.2 and 9.5, running on AIX and Linux,
respectively) where we use LDAP for authentication.
A problem we have been fighting with for a long time is this:
When people use DB2 Control Center to connect to a database on another
|
| Update across 2 tables | 04 Feb 2008 17:53 GMT | 4 |
I have 2 tables.
test1 : A integer, B integer - (1,1) , (2,2)
test2 : A integer, B integer (1,2) , (2,3)
I have to update test1, set test1.b = test2. b where test1.a =
|
| multirow fetch with embedded SQL | 04 Feb 2008 16:41 GMT | 7 |
Is there a way to do a multi-row fetch in to a COBOL table with DB2/LUW?
Apparently the following is supported in z/OS, but not LUW (or at least I
couldn't get it to work):
WORKING-STORAGE SECTION.
|
| db2 restore database TSM | 02 Feb 2008 17:35 GMT | 1 |
im trying to restore a 500GB database to a target AIX server..
its actually my first time doing this..it takes me 2hours to perform a
full backup..however when i try the restore, it took restore 8hours
just to restore 40% of the db2 Database and still running..
|
| QUESTION: Tablespace containers not being cleared... | 01 Feb 2008 15:07 GMT | 1 |
Hi, all.
Background:
Windows server 03 R2, running db2 8.2. Development environment.
I inherited this server some time ago, so do not have its entire
|
| db2 to oracle migration | 01 Feb 2008 03:37 GMT | 74 |
are most IT shops migrating from db2 to oracle?
|
| Query using a different index than expected | 01 Feb 2008 02:41 GMT | 4 |
I have the table in which there are indexes on
Index1 --> col1
Index2 --> (col1, col2, col3, col4)
If i execute the query "Select * from Table where col1 =<value>,
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread