Welcome to the Planet DB2 Blog
Sharing best practices and innovative approaches to the continually evolving world of IBM mainframe database and Db2 technology.
Get an Internship With My Team at IBM
I have an amazing opportunity for students who are looking for an internship starting in May (2021). This is your chance to work on cutting-edge technologies, in a fantastic team, and positively impact millions of learners worldwide in the process. When I asked for quotes from our current interns on the team, here is what they had to say: “Why are you wasting time writing a post.” — John “I’m debugging here.” — Samantha “For Pete’s sake Antonio, it’s 3 am in the morning.” — Tyler Jokes aside, our current (and past) interns absolutely love their experience in our team
The post Get an Internship With My Team at IBM appeared first on Programming Zen.
IMS Open Transaction Manager Access (OTMA) is a component of IMS TM and is a transaction-based, connectionless client/server protocol
IMS Open Transaction Manager Access (OTMA) is a component of IMS TM and is a transaction-based, connectionless client/server protocol. The implementation of OTMA is specific to IMS in a z/OS sysplex environment and the domain of the OTMA protocol is restricted to the...
Cloud tutorial on serveless web app and eventing
A follow-up from my last post on Python decorators:Solution architectureSome years back, on IBM Cloud, we introduced an IBM Cloud solution tutorial for GitHub traffic analytics based on Cloud Foundry and IBM Cloud Functions.
A Cloud Functions action i…
It Matters Where Your Join Clauses Go
Explicit Join vs. Implicit Join When writing SQL there are two places you can define how tables are joined. The first is explicit, and is specified after the the keyword ON in the join clause like this: SELECT * FROM table_a as a JOIN table_b as b ON a.id=b.id The...
Pseudo-decorators for my Python Flask app
Secured Python Flask app on Code EngineRecently, I migrated an existing Python app from a Cloud Foundry to an IBM Cloud Code Engine deployment. The Flask app uses decorators for the routes and for OIDC-based authentication. For usability, the app shoul…
Using s3cmd with DB2 Backup
Following on from a previous blog about using the s3cmd utility with export and import one of the most asked questions was ‘can I use this with backup’, to which my first thought was… no – the backup file name is generated by DB2 including a timestamp so it wouldn’t...
Db2 for z/OS: Why You Might See a Lot of Catalog Access for Package Authorization Checks
From time to time I will receive a note from a Db2 for z/OS DBA, asking for help in understanding why there is a larger-than-expected amount of Db2 catalog access activity associated with package authorization checks, and what can be done to address that situation. In...
JWT token authentication in Db2 runtimes like Python or Node.js
Python script connecting to Db2 with JWTSome weeks ago I discussed how to configure JWT-based token authentication in Db2. I set up Db2 to accept JWS identity tokens and then connected to my test database using the command line. But how do you connect …
DB2Night Show #Z114: Tuning SQL that Still Works!
Presented by: Sheryl LarsenWorldwide Db2 Z Solutions Ambassador
, BMC Software
“The DB2Night Show #Z114: Tuning SQL that Still Works!” Replays available in WMV and M4V formats!
100% of our studio audience learned something!Sheryl di…
Trevor Eddolls highlights key takeaways from the 2021 Arcati Mainframe Yearbook
I’m reliably informed that the 2021 edition of the Arcati Mainframe Yearbook has now been published. This fascinating publication is completely free and can be downloaded from the Arcati website. It’s interesting that there are still some mainframers who haven’t come...
Featured Articles
Accelerating Your Db2 Database
by Larry Strickland
Db2 for z/OS: Why You Might See a Lot of Catalog Access for Package Authorization Checks
by Robert Barnes
Track IBM license usage with AWS License Manager
by Khurram Nizami