DB2 is a relational DBMS (Database Management System) created by IBM.
Questions tagged [db2]
108 questions
0
votes
1 answer
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 return the following error message:
SQL1092N …
Muhammad Hewedy
- 101
- 5
0
votes
1 answer
Is there a dedicated administrator connection on DB2?
When using Microsoft SQL Server, there is this handy thing called dedicated administrator connection. You can tell the database to drop all connections and not open any new ones, but keep the one you use right now alive for administrative…
Tim Büthe
- 352
- 2
- 5
- 16
0
votes
1 answer
DB2 LUW tools for diagnosing issues when the stuff hits the fan
I am no DBA and very much a novice when it comes to DB2 so even 'obvious' answers are welcome to this question:
I love db2top but sometimes I cannot get it to run if the load average is high on a db2 LUW.
This morning I was looking at an issue where…
Ichorus
- 485
- 1
- 6
- 12
0
votes
2 answers
DB2 insert performance - How to measure
[From stackoverflow]
Im trying to find a way to speedup my inserts to a DB2 9.7.1 (ubuntu linux)
Im watching vmstat and trying to gather some statistics via the db2 get snapshot commands but im not able to figure out which numbers im looking for to…
svrist
- 183
- 7
0
votes
1 answer
How do I start DB2 on an Amazon EC2 Volume?
I've got an instance of DB2 installed as part of an IBM WebSphere Portal development AMI on the Amazon EC2 cloud. Its installed a separate, persistent file system from the rest of the AMI.
Yesterday, the AMI was terminated, and DB2 went down as…
Spike Williams
- 188
- 1
- 9
0
votes
1 answer
Enabling DB2 Database for Full Text Searching
I'm trying to enable full text searching on a DB2 V9.5 database, SuSe Enterprise Linux.
Net Search Extender has been installed and db2text service starts without problems.
When I execute the following command:
db2text ENABLE DATABASE FOR TEXT…
Michael Sharek
- 101
- 3
0
votes
1 answer
JDBC To DB2 for i is Slow when host server is Windows 2019 or 2022
This is a strange issue. I am trying to get a server upgraded from Windows Server 2016 Data Center to anything newer. We have tried 2019, and 2022. This server is an ETL server for running Talend Open Studio, it is a connection between MS Sql Server…
jmarkmurphy
- 171
- 7
0
votes
1 answer
SQL5043N Support for one or more communications protocols failed to start successfully
We have db2 express-c x86_64 installed on Ubuntu Hardy (8.04). When I try to start the server, we see the following which we think is preventing db2 from acquiring port 50000 (nmap -sS -O 127.0.0.1 does not show db2):
$ .…
Lightbeard
- 239
- 1
- 5
- 12
0
votes
1 answer
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 stop/start from the admin console, it says I do…
Andrea Girardi
- 366
- 3
- 6
0
votes
1 answer
DB2 systemd startup
I have a DB2 systemd startup unit that is being denied by SELinux. Here is the unit:
[Unit]
Description=IBM…
Kevin Huntly
- 18
- 1
0
votes
0 answers
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 special characters (for example, á) but when i change…
Nicot3
- 1
0
votes
1 answer
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 database and we are provided with only ODBC…
0
votes
0 answers
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 in account is created on the same machine. This…
0
votes
1 answer
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 affect programs RPGs that need recompilation.…
0
votes
1 answer
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.
Nicolas
- 1