Explore DB2 on Experts Exchange

Expert Solutions for Your Tech Problems

DB2

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-r...

Read more
  • 5.8K Content
  • 1.2K Contributors

Expert Spotlight
Database Administrator / Software Engineer

Over 20 years of experience as an Application Architect/Developer, a Database Administrator, and a PM focusing on performance.

Troubleshooting Solution

Is IBM DB2 Community database compatible with Windows 11?

11

Is IBM DB2 Community database compatible with Windows 11?

Article

Recursive SQL in DB2 (Converting rows to columns)

4
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence)


A …
Troubleshooting Solution

DB2 SQL - find uptime values in a table

163
Hi all,

I have hundreds of identical tables - one for every hour:
        I_YEAR INTEGER NOT …
Advice Solution

Query to find rows with same id in column1 and different values in column2

5

DB2 11.5 on windows

This should be easy but for some reason I just can't wrap my head around it.  I

Troubleshooting Solution

DB2- update table 1 where records do not exist in table 2

3

Hi.  I have two related DB2 tables, ITEMA and ITEMB.  At some point records were deleted from ITEMB

Troubleshooting Solution

Is there a RGZPFM option that will not update the previous or existing Relative Records Numbers (RRNs)?

3

Secondary replication tool is using Relative Record Numbers (RRN)s for table that do not have a

Troubleshooting Solution

Monitoring DB2 11.5 on Windows

13
DB2 11.5 on Windows 2019.

I need to find a way to monitor my DB2 11.5 databases.  Right now I am …
Troubleshooting Solution

DB2 11.5 Change GENERATED BY DEFAULT FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP column

12
DB2 11.5 on Windows.

We added this column to most of our tables to see when last update was made for …
Troubleshooting Solution

Error using itoolkit for IBM XML Using Python

byKzKrew
2
Using the following code to connect to IBM DB2 database

from itoolkit import *
from itoolkit.transport …
Troubleshooting Solution

DB2 11.5 Script out all indexes for database

10
DB2 11.5 on Windows.
I am cleaning up unused indexes on my DB2 server and I would like to script them …
Troubleshooting Solution

DB2 Activities that would require a restart

4
DB2 11.5 on Windows

This is an odd question but I have been asked to come up with a list of DB2 …
Troubleshooting Solution

How to Slow Down a AS400 .mac Macro when Call Using "StartMacro" Function Within VBA Code

8
I am having problems playing back an AS400 (.mac) Macro when my VBA Code calls the .mac file Using …
Troubleshooting Solution

DB2 10.5 HADR question

6
DB2 10.5 on Windows Server
I am using HADR to do a server migration.  Old server is primary and new …
Troubleshooting Solution

Create a logical file with select rolling date range

5
Hi. I have a very large IBMi DB2 file that I currently access via a view over ODBC from a separate …
Article

Recursive SQL in DB2 (Converting Columns to Rows)

2
Recursive SQL in UDB/LUW (it really isn't that hard to do)

Recursive SQL is most often …
Troubleshooting Solution

Can I set a flag in my query to show a field that tells if data also exists from the same query with a WHERE entry change

9
I have an existing query listing every order number where part number 1234 was ordered that also …
Article

Setting the Session Date Format in DB2 UDB for AS/400 / iSeries / System i

2
November 2009

Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB …
Troubleshooting Solution

Use IBM MQ with DB2 to replicate table level data

9
I am currently running DB2 10.5 on Windows.  I have 4 servers: Dev, Test, Stage, and Prod.  I am …
Troubleshooting Solution

DB2 10.5 Locking Issue

6
I have a process that reads a flat file into a staging table and then mergers (separate merge …
Troubleshooting Solution

When should I use PRIQTY -1 and SECQTY -1 when creating a DB2 tablespace?

4
Greetings, experts!

In DB2 v10 for z, as with most mainframe stuff, I've noticed that most DBA's like …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more