| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 16:00:47 GMT
content-type: text/html; charset=utf-8
cf-ray: 963c6481c8236cd6-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=60c6fda7-e324-41b4-b3e7-9974a1415142; expires=Thu, 23 Jul 2026 16:00:47 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 2be82607-2415-4552-a6b0-6883d9722d61
x-worker-origin-response-time: 1036000000
x-dns-prefetch-control: off
set-cookie: prov=60c6fda7-e324-41b4-b3e7-9974a1415142; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=l2FBn6p4v7S5jh0r9_xM5VRGOoBUuFyDXTc.rxFQVYA-1753286447-1.0.1.1-vRy6314I9a57KSMRrZfR9zHXqERCSg_VD1dWAvcpLl79SgPvOyuIBY7DEu9.n.HzcLGAEvqtC.CpZV.RQRSBMIkLmuXTTxE2rsWLkvufoK8; path=/; expires=Wed, 23-Jul-25 16:30:47 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=cTmvG9E_snDjU1z1as93Rb_Pv.IGZReWj_xHeu_V9Gs-1753286447432-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'db2' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 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
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [db2]
Db2 is a family of relational database management servers developed by IBM. It runs on multiple platforms, including Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows.
838 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
29
views
Running icr.io/db2_community/db2 without --privileged=true?
Has anyone managed to run icr.io/db2_community/db2 without using --privileged=true? The following works fine:
podman run -it --replace --privileged=true --hostname=db2host --name db2server --...
0
votes
1
answer
15
views
Query for DB2 z/OS Table Size
I need to check the size of some tables to get an indicative idea of how much space (in MB) they will occupy when I ingest them into another database.
I have written this query (*) to obtain the ...
0
votes
0
answers
50
views
DBeaver : Error on connecting to DB2 database using SSL Certificate
Trying to connect to DB2 database through DBeaver (DB2 for LUW) using SSL certificate on Windows 11 machine. I have the SSL certificate which I have converted to .jks file using the command
keytool -...
3
votes
1
answer
63
views
0
votes
1
answer
46
views
Proper method to reset DB/2 database
I am setting up a lab environment in DB/2 11.1 on Linux where I have a DB with a few tables, views and authorities. Once it is all configured, I take a backup with
db2 backup db MYDB online to /opt/...
2
votes
2
answers
88
views
DB2 LUW maxTransports: what is it currently set to?
RHEL 7.9
$ db2level
DB21085I This instance or install (instance name, where applicable:
"db2dlt01") uses "64" bits and DB2 code release "SQL11014" with level
...
0
votes
2
answers
104
views
DB2 LUW - Is the db2/V11.5 directory needed for V11.5.7.0?
According to db2level, we're currently running DB2 v11.5.7.0 (on RHEL 7.9). It was upgraded from 11.5 before I arrived.
This might sound like a stupid question, but are the V11.5 files required for ...
2
votes
0
answers
46
views
How to troubleshoot SQL2009C A backup failed due to inadequate memory resources in DB2
I backup my DB2 with NetBackUp throught a master server. The full or incremental night backup in automatic mode failed with this error message :
SQL2009C A backup or restore failed due to ...
2
votes
1
answer
78
views
How do I get the value of PI in Db2?
Some DBMSs have a pi() function to give the value of π. I can’t find the equivalent for Db2.
I can use radians(180), I suppose, but is there something more direct?
1
vote
1
answer
66
views
How do I check a date in a DB2 table?
Is it possible to include a check for a date in a Db2 table?
I have tried:
CREATE TABLE customers (
id int GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
email VARCHAR(60) NOT NULL UNIQUE,
-- ...
0
votes
0
answers
63
views
Is there a DB2 equivalent for SQL Server's sys.dm_db_missing_index_details?
The title pretty much says it all. Moved back to the mainframe recently and am "manually" finding various indexes that would help.
In Microsoft world, SQL Server has sys....
0
votes
0
answers
60
views
Replicate DB2 to SQL2022
I have an application on an IBM AS400, under a DB2 database system. I am currently in the process of looking for a replacement for the replication technology we are using to bring data on the SQL ...
0
votes
1
answer
56
views
How to obtain the result of a dynamic query without a cursor in an SP?
I tried creating a procedure to adjust a sequence according to the max value in a column. To get the max value from the column and store it in a variable I ended up using a "dummy" cursor. I ...
0
votes
1
answer
68
views
How to get TCP port number of currrently connected Db2 connection?
On Db2 v11.5 on Linux I can get Db2 instance TCP port number by:
db2 get dbm cfg | grep SVCENAME
cat /etc/services | grep db2c_
But I would like to get above info with SELECT statement. I would like ...
0
votes
0
answers
49
views
Db2 - Enable specific admin function(s) for generic, non-admin users
In Db2 (v11.5, 12, LUW) - what is the best way to grant/enable specific administrative functions with required permissions for applications?
E.g. a client/server application wants to make dynamic ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
db2-luw × 269
db2-10.5 × 43
iseries × 37
backup × 30
performance × 28
stored-procedures × 28
sql-server × 27
db2-midrange × 25
oracle × 23
linux × 22
restore × 21
db2-11.5 × 18
windows × 17
db2-9.7 × 16
index × 16
db2-zos × 15
tablespaces × 15
trigger × 15
migration × 14
optimization × 13
permissions × 13
transaction-log × 13
functions × 12
logs × 12
archive × 11
more related tags
Hot Network Questions
- Make a Mulenère encryption program
- Create a custom filter in WordPress extensions page
- What is the consistency strength of Russell & Whitehead's ‘Principia Mathematica’?
- A word that describes some people
- Why is this endgame winning for Black?
- When is XLOOKUP() faster than VLOOKUP()?
- Ubuntu Server installation -- options for boot disks are grayed out
- Story about a room on Mars that contains God
- When you view a historical event with an incorrect modern lens
- Why does my door knob bolt catch in the retracted position?
- Did Germany declare the Donetsk People’s Republic to be a terrorist organization, at some point?
- Will a restless MCU survive long enough?
- Will I lose my seat reservation on Deutsche Bahn EC if I skip the first leg?
- Fit text on TWO pages by varying font size automatically
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- In this video why are the astronauts wearing only their flight suits during dragon training while in others they are in their full starman suits?
- Define command valid only for a specific environment in expl3
- Is it legal for businesses to give financial incentives for leaving positive reviews on review sites (e.g., Google Maps, Yelp, Facebook, Amazon)?
- bootstrapping for variance estimation takes too long
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- Is there a way to move the cursor specifically to the beginning of the visually selected region (not just toggle like `o`)?
- How to run CorePipeline.Run("contentSearch.PopulateSolrSchema", args); outside of regular sitecore environment
- What's the point of all-wheel drive (AWD) in RoadCraft, if vehicles consume no fuel?
- Pourquoi "better to use ne alone" dans ce cas, "with savoir followed by an indirect question"?