Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [db2]

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

0
votes
0answers
22 views

Recovering from a DB2 Failure

My system had a full hardware failure last night, I spent all day bring it back up. Long story short after a lot of "Why isn't XDB starting?" I ended up reviewing the logs and finding that the ...
0
votes
0answers
23 views

JVM is crashing in a call of RUNJVA from a CL program on AS400 machine

Calling a runnbale jar from a CL program by using RUNJVA command two times with different parameters as,      RUNJVA     CLASS('/MYFOLDER/JAVA/project.jar') +                PARM('INIT' '129.186.121....
0
votes
2answers
73 views

DB2 10.5 HADR read only standby applications don't reconnect to primary

Scenario: server SERV_A, database DBNAME primary server SERV_B, database DBNAME standby with DB2_HADR_ROS enabled Then this situation occurs: connection CON is made from client to DBNAME when ...
0
votes
1answer
104 views

How to track db2 database changes from linux without triggers or db modification

I've got an assignment where I need to create a shell script to track just the changes to the employees table (DB2 database) record for any insert, delete or update that the HR department perform to ...
0
votes
0answers
238 views

Unable to install php_ibm_db2.dll on PHP 5.6

I'm getting the following error when trying to start Apache. I've confirmed the extension is in the folder and other extensions such as sqlsrv work just fine. This is the only one that seems to fail ...
0
votes
1answer
91 views

How to do REORG command on DB2

I want to reorganize(offline) some db2 tables. Also I want to executing runstats command after reorg command. I have a question. Do I need to stop db2 database or deactivate or both of them before ...
0
votes
1answer
871 views

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 ...
0
votes
3answers
621 views

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 ...
0
votes
1answer
67 views

DB2 and Linux remote server replication

I'm using DB2 10.5 and SLES 11 SP4. My Question is, how would I replicate a remote server's db without having to ssh in and manually export/import.
0
votes
1answer
89 views

DB2: How to retain backups if automatic backup is enabled

Is there a way to retain the backups or configure the interval when they are deleted? According the manuals it's not possible: "If backup to disk is selected, the automatic backup feature will ...
0
votes
1answer
713 views

Export Data from IBM DB2 into an SQL-INSERT Skript using IBM Data Studio Client or another tool

I have here a running IBM DB2 Database. I would like to export data from some tables into an SQL-Insert Skript, for example for the table T1 with the following content: --------------- | Col1 | Col2 |...
0
votes
1answer
200 views

Confused about database names and remote locations on AS400

I'm taked with buildig a web service that gets it's data from an old AS400 database server. I'm trying to connect over nodejs using https://github.com/ibmdb/node-ibm_db and i'm getting this error on ...
2
votes
0answers
310 views

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/...
2
votes
1answer
906 views

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 ...
0
votes
1answer
520 views

IBM Cognos Business Intelligence 10.2.2 on WebSphere Application Server 7.0.0.29 fails to start, possibly due to a missing classpath entry

I have a server running IBM AIX 6.1.7.15 TL07 and I am trying to install Cognos Business Intelligence 10.2.2 on WebSphere Application Server Network Deployment 7.0.0.29, using a server cluster to ...
0
votes
1answer
181 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 ...
1
vote
0answers
62 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 ...
0
votes
1answer
35 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 ...
1
vote
0answers
47 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 PASSWORD]...
0
votes
1answer
243 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
109 views

Does DB2 accept SSL3 connections?

Does DB2 allow connection through Secure Sockets Layer version 3 (SSL3)? To be more exact, will a program using SSL3 connection get an access to DB2? or will it fail? If it does accept it, is there ...
0
votes
1answer
3k views

Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator

I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem. I've looked through the internet and found the following page that has some ...
0
votes
1answer
163 views

How can I uninstall ‘DB2 Enterprise Server Edition – SAPDB2SMP without the server crashing?

In 'Control Panel | Programs | Programs and Features' of Windows Server 2008, I can see an entry for ‘DB2 Enterprise Server Edition – SAPDB2SMP’. When I select it and choose ‘Uninstall’, it goes ...
0
votes
1answer
429 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 ...
3
votes
4answers
22k 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 ...
-3
votes
1answer
46 views

Storing db2 database on secondary hard drive [closed]

I have two hard drives one with os(ubuntu) and other just etc4 formatted. I want to store my database on this second hard drive. I tried searching online but there are very few resources online. It ...
1
vote
1answer
677 views

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.
1
vote
2answers
3k views

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 ...
1
vote
0answers
387 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 ...
0
votes
0answers
795 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
415 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 ...
1
vote
0answers
1k 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
2answers
472 views

Simulating AS400 iSeries for ADO.NET

I' have to write an import procedure in c# for a customer. The procedure needs to read data from an AS400 iSeries, so my first Question is: what's "better" (pro/cons) between direct connection (using ...
0
votes
1answer
593 views

php_ibm_db2.dll on IIS 7.5 using PHP 5.3 error message

I'm trying to use ibm_db2 extension to access iSeries DB2 database. This is the testcode (taken from here) <?php $database = 'ALI452BFAL'; //library $user = 'STN452'; $password = '**********'; $...
3
votes
1answer
8k views

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 ...
2
votes
0answers
64 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 (...
0
votes
1answer
6k 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
0answers
2k 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
348 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. ...
0
votes
2answers
4k views

No match for a database image file was found based on the source database alias “URCDB”

I used IBM Data Studio to backup a test database named URCTEST. Now, I want to restore it to the actual (empty) database, URCDB. I've got little experience with IBM DB2, so I assumed this was ...
0
votes
1answer
80 views

DB2-Express-C and Postgresql using raw harddrive as datastore

I have a system running Solaris with 2 harddrives. One holding the OS and the other unpartitioned. I was thinking about using the second as database space. My question is, if it is possible to let ...
1
vote
1answer
4k views

DB2 'The string constant beginning with…is too long' error when inserting 40000 characters to CLOB(50000) field [closed]

I have created a CLOB(50000) field in a DB2 table, and verified it has correctly created with DB2 DESCRIBE TABLE dbname ...however I received the following error message even when only attempting to ...
2
votes
2answers
931 views

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 ...
0
votes
1answer
93 views

OS LDAP auth when LDAP server located in same machine

Is it normal to make LDAP authorization on Linux OS (CentOS 6.3) when LDAP server will run on same machine? I think I can't make authetication through LDAP when I start operating system, because my ...
0
votes
1answer
710 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 ...
3
votes
2answers
178 views

Migration from oracle to DB2

I want to migrate my oracle schema to db2. Any tool available for migration? Please help
-1
votes
2answers
586 views

Regular expressions to find SQL Errors in Logs

I am running a log parser to find SQL errors in my log files. If the search string (regular expression) is evaluated to true, the line will be marked. So far I used the search expression "SQL0", which ...
1
vote
1answer
3k 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
69 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 -rw----...
0
votes
1answer
123 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 ...