Questions tagged [db2]
DB2 is a relational DBMS (Database Management System) created by IBM.
107
questions
0
votes
1
answer
28
views
Unable to connect to local DB2 instance
I have installed an Enterprise version of DB2 on my local Windows 11 pro laptop for some development tasks.
Installation proceeded without errors but, it seems I cannot connect using TCP. If I try to ...
- 366
0
votes
1
answer
106
views
DB2 systemd startup
I have a DB2 systemd startup unit that is being denied by SELinux. Here is the unit:
[Unit]
Description=IBM DB2
After=network.service
[Service]
Type=forking
EnvironmentFile=/user/home/dvdxadm1/sqllib/...
- 18
0
votes
0
answers
19
views
Issues with DB2 encoding using Laravel on Ubuntu 20.04
Recenlty i finished a development phase in WSL with Ubuntu 20.04.
Now i'm migrating the project to a live Ubuntu in the same version (20.04)
I'm having issues with the encoding, in WSL i see the ...
- 1
0
votes
1
answer
135
views
How to connect to db2 database if we are provided with DB2 ODBC connection via System DSN?
DB2 database connection details are provided as ODBC registry file. The file is imported and the connection details are stored under System DSN.
Now by using which GUI tool one can connect to the DB2 ...
0
votes
0
answers
45
views
Is it possible to set up the database connection if we are provided with ODBC registry file?
One of the users already has all the OBDC connections configured on to the RDC user account. That machine is used to connect to all the databases.
A new user on boards into the organization, his log ...
1
vote
2
answers
4k
views
How to setup privileged in docker swarm?
I am running a db2 container sample using this docker command.
Reference docker image
docker run -itd --name mydb2 --privileged=true -p 50000:50000 -e LICENSE=accept -e DB2INST1_PASSWORD=Notallowed1! -...
- 332
0
votes
1
answer
130
views
MySQL to MariaDB migration on IBM i connected to DB2 with IBMDB2I storage engine and RPG programs
we are in the process of migrating MySQL to MariaDB database on IBM i (AS400) server, but the problem is that MySQL DB has some databases connected to DB2 with DB2 storage engine so the migration will ...
0
votes
1
answer
153
views
How to send and use the V7R3 created program object in V7R2 version of iseries/AS400?
I have tried using save file with target system version *PRV/V7R2M0 but save file not saving the objects which are created with V7R3. How can i still use the V7R3 object in V7R2.
- 1
0
votes
1
answer
334
views
How do I know when a new IBM DB2 Express-C version is released?
How do I know when a new IBM DB2 Express-C version (or security patch) is released? Please, don't suggest following #db2luw... :)
Update:
According to this page security patches (called "fix packs") ...
- 117
0
votes
2
answers
3k
views
Activation key part number for Db2 Data Server Client 11.5?
I think I have reached the end of Google, but still not able to find the part number I need to download the license file for IBM Data Server Client 11.5. Not listed here https://www.ibm.com/support/...
- 273
2
votes
1
answer
1k
views
ODBC Driver for IBM iSeries AS400 version V7R1
I am trying to connect to IBM iSeries using pyodbc, a Python interface for ODBC, on Linux Red Hat (Intel 64bit arch).
The following is what I have done:
Installed gcc-c++ (needed to compile pyodbc), ...
- 131
0
votes
1
answer
596
views
Db2 backup only transaction log files
What is the possibility to take transaction log (Archive log) backup in Db2 database.
I know that online backup takes archive log backup by default but what If I want the archive log backup after ...
- 3
2
votes
1
answer
72
views
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 ...
- 21
0
votes
2
answers
447
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 ...
- 165
0
votes
1
answer
390
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 ...
- 11
0
votes
0
answers
400
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
1
answer
267
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 ...
- 3
1
vote
1
answer
2k
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 ...
- 123
1
vote
3
answers
3k
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
...
- 81
0
votes
1
answer
100
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.
- 31
0
votes
1
answer
375
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 ...
- 1
0
votes
1
answer
2k
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 |...
- 223
0
votes
1
answer
464
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 ...
- 133
2
votes
0
answers
534
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/...
- 217
2
votes
1
answer
4k
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 ...
- 121
0
votes
1
answer
696
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 ...
- 151
0
votes
1
answer
465
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,037
1
vote
0
answers
91
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 ...
- 558
0
votes
1
answer
42
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 ...
- 125
1
vote
0
answers
59
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]...
- 1,037
0
votes
1
answer
327
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:
...
- 1
0
votes
1
answer
116
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 ...
- 109
0
votes
1
answer
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 ...
- 113
0
votes
1
answer
171
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 ...
- 1,540
0
votes
1
answer
677
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 ...
- 111
3
votes
4
answers
35k
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 ...
- 165
-3
votes
1
answer
54
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
1
answer
698
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.
- 165
1
vote
2
answers
4k
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 ...
- 165
1
vote
0
answers
447
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 ...
- 11
0
votes
0
answers
940
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 ...
- 101
0
votes
0
answers
585
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 ...
- 123
1
vote
2
answers
620
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 ...
- 135
0
votes
1
answer
838
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 = '**********';
$...
- 155
3
votes
1
answer
15k
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 ...
- 143
3
votes
0
answers
70
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 (...
user181206
0
votes
1
answer
8k
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 ...
- 334
1
vote
0
answers
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
[...
- 983
1
vote
0
answers
394
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. ...
- 111
0
votes
2
answers
5k
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 ...
- 165