Tagged Questions
0
votes
1answer
24 views
Command to list event monitors in DB2
I see the following commands:
drop event monitor
set event monitor
create event monitor
But nothing like list event monitor or get event monitor. Is there a DB2 command to list all current event ...
1
vote
1answer
378 views
DB2 Integrity Checks and Exception Tables
I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on.
A few notes on this ...
0
votes
1answer
312 views
Need DB2 OLEDB Driver / ODBC Driver
I am trying to establish a connection between excel and db2. I am able to successfully query and retrieve data from my DB.
I am using the below connection string
...
0
votes
1answer
63 views
Oracle/DB2 compare
I need to find definitions or explanations (DB2 and Oracle) for:
instance
database
connection
authority
authorization
transaction log
tablespace
application
agent
lock
lock timeout
Do someone know ...
1
vote
1answer
485 views
SQL Error: -443, SQLState: 38111 when accessing table metadata on DB2 zOS
I'm getting following error when using Hibernate in a Java application over my DB2 database.
This error occurs with one DB2 database and not with another (I'm almost sure the problem is in DB2 server ...
2
votes
1answer
407 views
How to migrate from DB2 to PostgreSQL database?
I have an existing Windows DB2 database that I'd like to move onto PostgreSQL. The users for the application can live with a weekend's worth of downtime. What's the best way to do that?
3
votes
4answers
7k views
How to find the next generated value for a auto-increment column?
I face some trouble with IBM DB2's auto-increment columns. At first, all my columns were defined as GENERATED ALWAYS, but since I had trouble with this when using the "db2 import ..." command, I ...
