Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [db2]

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

108 questions
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
  • 551
  • 1
  • 8
  • 18
2
votes
1 answer

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 migration: We are using db2move to export and load…
imthefirestartr
  • 53
  • 2
  • 7
2
votes
2 answers

Running DB2 universal client on 64 bits windows 7 machine?

We are trying to set up a development environment on a new machine. Previously we have used this software on 32bit windows XP machines. We tried installing the 32 bit version of DB2 universal client but the installation failed. Is there a 64 bit…
Shiraz Bhaiji
  • 2,229
  • 9
  • 34
  • 47
2
votes
3 answers

AS400 and Remote Commands

On the AS400 I want to remotely execute: strpgrprg topgr(userx) message(ALERT!) What options are available to me? update: I want to run a AS400 program from outside of the AS400. I want to execute this command (or similar) from a windows batch,…
WernerCD
  • 344
  • 2
  • 6
  • 18
2
votes
3 answers

Size of db2 database

How can I get the size of my UDB DB2 version 9.1 database? I tried firing getdbconfig from the command prompt. It gives all the configuration but not the size. Thanks :)
Rashmi Pandit
  • 194
  • 2
  • 12
2
votes
1 answer

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?
Dan
  • 620
  • 6
  • 18
1
vote
2 answers

How do I do a cross-platform backup/restore of a DB2 database?

I need to dump a couple of databases from DB2 for Mac and DB2 for Linux and then import the databases to DB2 for Windows. Unfortunately, when I try the standard backup and restore I get the following error: SQL2570N An attempt to restore on…
Pridkett
  • 176
  • 2
  • 8
1
vote
1 answer

Monitor SQL statements in DB2

I need to monitor SQL statements issued to DB2 database. I found the following article http://www.dba-db2.com/2010/01/trace-sql-statements-in-db2-database.html and I can to indeed capture SQL statements. The problem is that prepared SQL statements…
Alojzij Blatnik
  • 123
  • 1
  • 9
1
vote
3 answers

ansible - Run "command db2 update database manager configuration using svcename db2c_db2inst1" as db2 user

I am setting up ansible to install a DB2 on a linux server. Everything is working except in the last step I need to run: db2 update database manager configuration using svcename db2c_db2inst1 However, I cannot seem to run that as a unprivileged…
warhansen
  • 81
  • 1
  • 7
1
vote
2 answers

How to start db2 after Ubuntu 9.10 upgrade? Missing libstdc++.so.5

I just upgraded to Ubuntu 9.10 and now my db2 is not starting anymore. The error message reads as follows: db2start: error while loading shared libraries: libstdc++.so.5: cannot open shared object file: No such file or directory I guess, this is,…
Tim Büthe
  • 352
  • 2
  • 5
  • 16
1
vote
0 answers

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 files, and a small block size 8k or less for…
basin
  • 558
  • 1
  • 5
  • 22
1
vote
0 answers

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 | -d] [-r RDBNAME [-u USERNAME -p PASSWORD] ] <"SQLSTMT" | -i | -f FILENAME DEFAULT_LIB> However,…
Justin Dearing
  • 1,037
  • 12
  • 33
1
vote
1 answer

IBM DB2 9.7 end of service?

I'm trying to find the End of Service date for IBM DB2 9.7. I could only find some page that was from 2012, stating that it has not yet been announced. Thanks in advance.
user1340582
  • 165
  • 1
  • 2
  • 5
1
vote
2 answers

IBM DB2 9.7, cannot increase LOGFILSIZ or LOGPRIMARY values

I am using IBM DB2 9.7 LUW database. My current database configuration values for Circular logging is as follows: LOGFILSIZ: 1024 LOGPRIMARY: 13 LOGSECONDARY: 15 I get error that transaction logs are full, therefore I need to increase the log size.…
user1340582
  • 165
  • 1
  • 2
  • 5
1
vote
0 answers

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 properties and I find the new resource added under the…
Pops
  • 11
  • 2
1
2
3 4 5 6 7 8