DB2 is a relational DBMS (Database Management System) created by IBM.
Questions tagged [db2]
105 questions
8
votes
7 answers
Drop database on DB2 9.5 - SQL1035N The database is currently in use
I've never got this working the first time, but now I can't seem to do i at all.
There is a connection pool somewhere using the database, so trying to drop the database when an application is using the database should give this error. The problem…
Tommy
- 195
- 1
- 2
- 9
6
votes
4 answers
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 changed them to GENERATED BY DEFAULT. This is…
Tim Büthe
- 342
- 2
- 5
- 16
4
votes
1 answer
Restore DB2 database
Is there anyway to restore a db2 database whose backup was made in Windows XP , to a linux machine ?
I am using the same version of db2 on both the OSes -> DB2 Express-C 9.7
Source OS : Windows XP SP2
Target OS : Ubuntu 9.04
Manish Mathai
- 163
- 1
- 2
- 5
4
votes
5 answers
How to find DB2 port number (note: it does not use port listed in services file and db2 listing is missing from netstat command output) in windows?
I want to find DB2 port in windows, please help. Some information:
DB2 v 9.7 Personal Edition - new/fresh install
netstat command does not list db2 port.
db2 entry missing was missing in system32\drivers\etc\services file so, made an entry -…
Sannidhi
3
votes
4 answers
IBM DB2 9.7, force all connections of a specific database
I have a DB2 9.7 LUW instance with several databases. I am trying to take backup of a specific database, but Data Studio client reports that there is still an active connection so it fails.
How can I force the database to remove all active…
user1340582
- 165
- 1
- 2
- 5
3
votes
1 answer
How to establish ODBC connection through ssh tunnel?
I have SSH access to an iSeries (DB2 Database) through a firewall. I am trying yo make queries to a db in the machine using ODBC.
I have found several tables explaining what ports are used by the protocol but don't know what to do with this…
cabe56
- 143
- 1
- 1
- 4
3
votes
0 answers
Is it possible to enable WLM for Stored Procedures through DB2 on z/OS
If core WLM is not available for all built-in Stored Procedures in a DB2 on z/OS, would it be at all possible for a DB2 user with all privileges to setup the core WLM environments through a CLPPlus (or similar) connection to the DB?
I am trying to…
user181206
3
votes
2 answers
Migration from oracle to DB2
I want to migrate my oracle schema to db2.
Any tool available for migration?
Please help
Shoaib Muhammad Khan
- 133
- 2
3
votes
4 answers
iSeries DB2 - SQL GUI Tool
Can someone suggest a good free Database tool with SQL support for connection to an iSeries. Currently I am using the green screen and it is quite frustrating.
jax
- 207
- 1
- 5
- 12
2
votes
1 answer
Is it possible to build a queue sharing group on only a coupling facility and not use db2?
I keep reading docs that say the messages are kept in a cf and can be offloaded to smds or db2 if they are too large. This would suggest I could build out queues in a cf and offload large messages to disk and avoid db2 all together. Then other docs…
argh
- 21
- 1
2
votes
10 answers
Things every DBA for DB2 on Unix, Linux should know
What are the most useful resources for a DB2 DBA working on Unix or Linux?
Books
Web sites
Tools
etc.
Kevin Beck
- 101
- 1
- 4
2
votes
0 answers
Compiling PHP 5.5.7 with PDO IBM for IBM DB2
I'm trying to compile PHP 5.5.7 on an Ubuntu 12.04 with ubuntu precise partner repository enabled to allow to install IBM DB2 from db2exc package.
When I configure PHP with pdo ibm
source /home/db2inst1/sqllib/db2profile
./configure
…
corretge
- 217
- 3
- 9
2
votes
1 answer
IBM's iSeries ODBC driver not sending any traffic when invoked via isql or otherwise, getting [08S01][unixODBC] and [ISQL]ERROR: Could not SQLConnect
Note: I've replaced IP addresses, database names, and server users with examples. That shouldn't affect anything.
The Setup
I've installed unixODBC (yum install unixODBC) and IBM's official iSeries ODBC driver (yum install…
Agop
- 121
- 1
- 6
2
votes
4 answers
Which webserver should I use
I have a iseries database and I want to build webpages on top ot it. I want to use the Java platform and would like to have recommendations on the benefits of Apache vs Websphere as the best platform of choice. I do not have either at this point. I…
user18325
2
votes
2 answers
Configure DB2 LDAP authentication
I want to configure LDAP auth in DB2. From IBM docs I learned that first I need to configure LDAP authentication in operating system. But in documentation described old way of configuring LDAP for Operating system. RedHat recommends to use only new…
MyTitle
- 501
- 1
- 8
- 18