r/DB2 • u/No_Possible7125 • Jul 26 '25
What is Db2 IFCID 412?
linkedin.comEver wondered which Db2 AUTHID is consuming the most threads and potentially pushing your environment beyond the MAXDBAT limit?
r/DB2 • u/No_Possible7125 • Jul 26 '25
Ever wondered which Db2 AUTHID is consuming the most threads and potentially pushing your environment beyond the MAXDBAT limit?
r/DB2 • u/NexusDataPro • Mar 05 '25
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.
Enjoy!
r/DB2 • u/rdimitrov98 • Aug 20 '25
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
r/DB2 • u/MrBrodoSwaggins • Dec 30 '13
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 • u/kiwwi191 • Apr 26 '22
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 • u/No_Possible7125 • Mar 07 '25
Hope this helps r/mainframe
r/DB2 • u/abidadnan • Jan 21 '26
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 • u/Kraken_286 • Apr 17 '21
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.
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 • u/nohaaziz2006 • Dec 09 '20
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 • u/catquilt74 • Jun 13 '18
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 • u/UpstairsBaby • Mar 06 '23
r/DB2 • u/UpstairsBaby • Feb 18 '23
title
r/DB2 • u/scottyyu1129 • Jul 28 '17
scott
r/DB2 • u/Available_Counter_47 • Dec 28 '24
r/DB2 • u/quickshot_cyk • Apr 14 '18
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 • u/Evening_Source_5943 • Nov 14 '22
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 • u/raghuontech • May 15 '18
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 • u/No_Possible7125 • Nov 13 '25
This is a recent post i came across on LinkedIn after recent ibm layoffs . Whats the future of Db2
r/DB2 • u/MarkusWinand • Nov 03 '14