Questions tagged [db2]

DB2 is a relational DBMS (Database Management System) created by IBM.

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
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
1
2 3 4 5 6 7