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

learn more… | top users | synonyms (1)

1
vote
3answers
8k views

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 ...
0
votes
2answers
184 views

DB2 users and groups

Just want to know everyone's experience and take on managing users/authentication on a multi-node db2 cluster with users groups. I have 17 apps in production (project based company, only 2 online ...
1
vote
1answer
2k 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 ...
1
vote
1answer
965 views

How to connect to DB2 when the password ends with '!' in Windows

I am facing a problem to use the DB2 tools when using generic account with a generated password which ends with the Bang sign '!' to connect to DB2 database. I am not allowed to change the password ...
1
vote
1answer
2k 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
31 views

Making RUNSQLSTM Display errors interactively

If I run the command RUNSQLSTM SRCFILE(ZIPPY19811/QSQLSRC) SRCMBR(JUSTIN) from the greenscreen, I get the status message RUNSQLSTM command failed. but to get the actual error message I have to do a ...
0
votes
1answer
27 views

DB2 Scale out for vendor solution

Currently I'm dealing with a vendor application that uses DB2 Workgroup Server Edition 10.1 on Windows Server 2012 . Right now I'm able to scale up as demand increases, but eventually we will hit a ...
0
votes
1answer
169 views

DB2 crash on production redhat server

We have a redhat virtual machine (vmware vsphere) that is hosting the database for our application. The application runs normally, until at some point it crashes with the error below seen on db2diag: ...
0
votes
1answer
299 views

Create alias for UNIX username in LDAP for DB2

I want to use LDAP data for the authentication process in DB2. I have already configured DB2 via PAM to retrieve the information of the NIS server that is in the ActiveDirectory. It works perfect ...
0
votes
1answer
3k 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 ...
0
votes
1answer
489 views

Why does database of db2 HADR standby server deactivate automatically?

Im trying to configure SAP HADR with the primary and standby server. Configurations seems to be ok but the database of standby server deactivates automatically. When i run the command db2 activate ...
0
votes
1answer
65 views

What causes DB2 to have log file times out of order?

I routinely see the following in the logs of a DB2 LUW 9.7.4 server: -rw------- 1 db2inst1 db2iadm1 129M Feb 23 11:20 S0000045.LOG -rw------- 1 db2inst1 db2iadm1 129M Feb 23 12:10 S0000046.LOG ...
0
votes
1answer
111 views

DB2 to Oracle Migration

I am migrating a very large and complex database from DB2 to Oracle 11g. Can someone suggest any tools / processes to do this very quickly. My database is about 500 GB and it cannot have downtime ...
0
votes
1answer
443 views

DB2 2 Slow Authentication / Connection Establish

I have a DB2 server installed on Windows 2008, and found that the local OS users are instantly authenticated, but the server take a long time to authenticate LDAP (AD) users, more than 3 minutes but ...
0
votes
1answer
253 views

DB2 Express-C 9.5.2 error SQL0980C

We identified that the daily backup scheduled for our database was not obtained because the tablespace "SYSTOOLSPACE" was offline, so looking in the internet found that could be solved by running the ...
0
votes
1answer
157 views

How to do a database backup in DB2 in Vista?

How to do a database backup in DB2 in Vista? Whenever I issued this command (login in Vista as Administrator): restore database myDB from D: taken at 20081013134446 the command line processor ...
2
votes
0answers
53 views

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 ...
1
vote
0answers
25 views

Force disk cache even if guest uses direct i/o

Have IBM db2 on Rhel on Hyper-V on Windows Server. The *.vhdx file is on CSV. e.g. C:\ClusterStorage\volume1\hyper-v\oktest-lb1\oktest-lb1.vhdx. db2 uses O_DIRECT flag (uncached i/o) for its database ...
1
vote
0answers
31 views

db2 -S is hanging on IBMi

I can ssh into my IBMi and start qsh. If I type db2 with no parameters I get the standard help message: db2 USAGE: CMD [-v] [-S] [-s] [-t | -T<char> | -d] [-r RDBNAME [-u USERNAME -p ...
1
vote
0answers
205 views

Getting the DB2 Resource online in Failover Cluster

I'm using DB2 10.1 Enterprise Server Edition on Windows Server 2012 R2 After adding the DB2 resource to the cluster using the db2wolfi command, I go to the resources tab which is in the cluster ...
1
vote
0answers
402 views

Example pyodbc db2 connection

I am trying to get a pyodbc connection (on a Centos machine), to a DB2 database running on an IBM i. Whatever connection string or configuration I add, I always get the same message .. Traceback ...
1
vote
0answers
1k views

Error code 610 backing up DB2 to TSM

I'm trying to back up a DB2 database using Tivoli Storage Manager (TSM), but it's erroring out. I'm now getting this error message: [db2inst1@hostname ~]$ export DSMI_CONFIG=/etc/adsm/dsm.opt ...
1
vote
0answers
262 views

LAMP using ODBC to DB2

I have connected an openSUSE LAMP and an Ubuntu LAMP server to DB2 using ODBC. The openSUSE system we're using for a development environment, and the final deployment is to be on the Ubuntu system. ...
1
vote
0answers
705 views

Errors installing iSeries Access for Windows on Win 2008 server

I am desperately in need of help here. I am trying to install the iSeries Access for Windows software on our development server and can't get past the install. Here were my installation ...
0
votes
0answers
6 views

Issue while installing ibm_db on RHEL with easy_install

easy_install ibm_db error: Searching for ibm-db Reading https://pypi.python.org/simple/ibm_db/ Best match: ibm-db 2.0.7 Downloading ...
0
votes
0answers
417 views

AIX JFS2 I/O performance problems

I have a fresh installation of AIX 7.1. I noticed that JFS2 file system with logging enabled (log=/dev/hd8) is dramatically slower than one with log=NULL. Simple zip archive extraction takes 5 minutes ...
0
votes
0answers
322 views

Windows DB2 9.7 FP8 - The request failed because private virtual memory could not be allocated. SQLSTATE=57011

I have a Windows DB2 9.7 FP8 server running on Windows 2003 x86 that for some reason every time I launch Center Administrator or the CLI and try to connect to a database, I get the error "[IBM][CLI ...