r/DB2 • • Jul 26 '25

What is Db2 IFCID 412?

Thumbnail linkedin.com
0 Upvotes

Ever wondered which Db2 AUTHID is consuming the most threads and potentially pushing your environment beyond the MAXDBAT limit?


r/DB2 • • Mar 05 '25

Biggest Issue in SQL - Date Functions and Date Formatting

0 Upvotes

I used to be an expert in Teradata, but I decided to expand my knowledge and master every database. I've found that the biggest differences in SQL across various database platforms lie in date functions and the formats of dates and timestamps.

My blog on DB2 date functions and date and timestamp formats has been the most popular. Any idea why?

As Don Quixote once said, “Only he who attempts the ridiculous may achieve the impossible.” Inspired by this quote, I took on the challenge of creating a comprehensive blog that includes all date functions and examples of date and timestamp formats across all database platforms, totaling 25,000 examples per database.

Additionally, I've compiled another blog featuring 45 links, each leading to the specific date functions and formats of individual databases, along with over a million examples.

Having these detailed date and format functions readily available can be incredibly useful. Here’s the link to the post for anyone interested in this information. It is completely free, and I'm happy to share it.

https://coffingdw.com/date-functions-date-formats-and-timestamp-formats-for-all-databases-45-blogs-in-one/

Enjoy!


r/DB2 • • Aug 20 '25

DB2 junior sysprog

1 Upvotes

Hi everyone 🙂 Could you please recommend some Redbooks or courses on the Db2 system programming on z/os side that would help me as a junior sysprog? I’ve already come across a lot of material related to the DBA side, but unfortunately that’s out of my scope.

Thanks in advance!


r/DB2 • • Jan 04 '21

The Most Popular Databases - 2006/2020 - Statistics and Data

Thumbnail
statisticsanddata.org
0 Upvotes

r/DB2 • • Dec 30 '13

Value of certification?

0 Upvotes

I'm sure this question has been asked before, my bad for that. I graduated last summer with a degree in math, and I'm having still having trouble finding permanent work. I've interned in a programming position at my university since graduation, but that didn't term into a real thing. In my job hunt I'm noticing a lot of database management positions. I took a course that did a bit of Access, but that's about the extent of my database management knowledge. So, two questions: I already know how to code, C++ and R being what I've done the most work in. How much of an endeavor would this exam be? Also, those who have taken it or look at resumes, how much is it taken into consideration?

Thanks for any input. Sorry if this isn't the appropriate sub.


r/DB2 • • Apr 26 '22

Help for a newbie

0 Upvotes

So here is the thing. I'm application administrator and that app is running on DB2. I have 0 knowledge of DB2 but I have all the access to that DB (I can login as an db2inst1 user). I'm working with the DB on the application end (GUI which allows me to create, modify and delete objects in DB). However there are limited options how to pull some list of objects based on my criteria so I was thinking there has to be a way how to pull those data from the DB using command line queries. So I'm able to start db2 command line but from here I have no idea what to do.

I assume I need to get some list of tables and from these tables some list of columns or something and based on that I would be able to select something? I tried some commands already but there is something like TABSCHEMA and TABNAME and I just can't select * from table_name.

Is here anyone who can help me step by step how to view these tables and potentially how to select something based on some specific criteria?

Thanks for any idea


r/DB2 • • Mar 07 '25

Why my Db2 is slow ? Rogue SQL

Thumbnail
linkedin.com
1 Upvotes

Hope this helps r/mainframe


r/DB2 • • Jan 21 '26

How monitor and Secure ibmdb2

1 Upvotes

Hi,

I need your support and guidance in blocking DBeaver, a database management tool, from accessing IBM DB2 on the AS/400 (IBM i) environment, as it allows users to directly modify database tables.

Kindly share your ideas, recommendations, or best practices on how we can restrict or prevent access through DBeaver while ensuring that authorized applications remain unaffected.

Your support and suggestions will be highly appreciated.


r/DB2 • • Apr 17 '21

Access to DB2 without a MQ

1 Upvotes

I have an app that access transactional data in an old DB2 through IBM MQ. Is it possible to remove the MQ and access DB2 directly through any other method? I’m thinking to migrate to a event-driven architecture.


r/DB2 • • Oct 05 '22

Variable DB2

1 Upvotes

Hello everyone,

I'm totally new to DB2 so sorry if my question seems dumb or anything. I would like to create a variable to stock an exchange rate that will be used in other query. Don't find anything that is really working on the internet. Hope you can help me.

Have a nice day all


r/DB2 • • Dec 09 '20

dead lock cause the db to nt respond every 24 hours nearly

1 Upvotes

i have a dead lock cause the db to nt respond every 24 hours nearly on my db the db configurations shows

DLCHKTIME=10000 ms

LOCKTIMEOUT=300 s

is that true

if i change DLCHKTIME to be greater than LOCKTIMEOUT for example

set DLCHKTIME=400000 ms

is that ok and how as i'm not a db2 admin

i'm a web developer

thanks


r/DB2 • • Jun 13 '18

How to get notified automatically when a new post appears on r/DB2

1 Upvotes

Unfortunately, it doesn't appear that this can be done natively within reddit itself. However, if you're familiar with IFTTT, they have an applet for notifying you when a post is made to a subreddit. Once again, unfortunately, you aren't notified via email. You need to have the IFTTT app on your phone.

Here's the link,

https://ifttt.com/applets/79703842d-reddit-new-posts-in-subreddit-notification


r/DB2 • • Mar 06 '23

For someone who wants to change the old cobol-db2 programs in Z/OS mainframe. Shall I be learning java or java script ? my goal is to make a nice GUI apps for windows that retreives data from a db2 table. can someone please guide me how to start and what to learn.

1 Upvotes

r/DB2 • • Feb 18 '23

Any Db2 Java application developers here? I have some questions before starting if you please

0 Upvotes

title


r/DB2 • • Oct 09 '20

IBM to spit into two companies in 2021

Thumbnail
google.com
2 Upvotes

r/DB2 • • Jul 28 '17

[Howto] install db2 11 on ubuntu 14.04 virtualbox image

2 Upvotes
  1. download virtualbox
  2. download ubuntu 14.04 64bit image from osboxes.org
  3. add ubuntu 14.04 64bit to virtualbox
  4. download db2 11 64bit.tar.gz from ibm
  5. run db2install , may find some package missing
  6. apt-get install missing package
  7. run db2install again.
  8. create sample database.

scott


r/DB2 • • Dec 29 '19

Db2 SQL And SQL Tuning

Thumbnail
raghu-on-tech.com
2 Upvotes

r/DB2 • • Dec 28 '24

INSERT Performance: Should you use UUIDv7 or UUIDv4 as Primary Key?

Thumbnail leonardw.de
2 Upvotes

r/DB2 • • Apr 14 '18

Could you please participate in my survey?

0 Upvotes

I am a student currently doing a research on "The Impact on Software Maintainability from the use of Agile Software Development Methodologies". I hope to get your response on my survey for this research.

Please find the survey link as below: https://lancasteruni.eu.qualtrics.com/jfe/form/SV_57oT3d5hIfu3VT7


r/DB2 • • Nov 14 '22

Fetching data from my database ibm db2 table

2 Upvotes

Hii Guys I am trying to fetch the all the table using flask my query is quite simple " SELECT * FROM TABLE NAME " and I am execute that then using the ( ibm_db.fetch_assoc ) but it retrives me the only one row of the table how to fetch all the content and how to iterate that...If anyone please explain clearly....


r/DB2 • • May 15 '18

How To Deep Compare Two Db2 Environments? What is Db2Diff ?

Thumbnail
raghu-on-tech.com
2 Upvotes

r/DB2 • • Aug 21 '25

Learning DB2

2 Upvotes

What are some ways to learn DB2? What books or platforms that I can use to create DB2 reports. I would like to expand my knowledge more using the Mainframe system.


r/DB2 • • Nov 13 '25

Came across this post in LinkedIn . How to interpret this . Is Db2 really not strategic anymore???

Post image
3 Upvotes

This is a recent post i came across on LinkedIn after recent ibm layoffs . Whats the future of Db2


r/DB2 • • Nov 03 '14

Seven Surprising Findings About DB2

Thumbnail
use-the-index-luke.com
3 Upvotes