IBM Tech TV is the always-on platform for the latest technical talks, interactive coding sessions, and up to date information straight from IBM experts. Tune in to IBM Tech TV episodes covering topics that are key to enhancing your skills and relevant to your industry and applications you’re building.
Using something better than DSPDBR
I am sure we have all used the Display Database Relations command, DSPDBR, to establish any file’s or table’s dependent objects. We can also use a SQL Table Function to give us more (better) columns of data than the DSPSBR command does.
But before I start giving examples of using this Table function I need something to work with. Let me start with a very simple DDL table:
01 CREATE TABLE MYLIB.TABLE1
02 (FIRST VARCHAR(20))
I do not need to insert data into the table.
Next I will create an Index over my Table:
How to Remove 96011 APAR Patches
In order to update RDi 9.6.0.11 to the next release, you WILL need to remove ALL of the APAR patches we provided. This video shows you how to see if they are installed, and if so how to remove them before updating to the next release.
From: Steve Ferrell RDi Videos
Had to reschedule from today to tomorrow at 1pm est.
Had to reschedule from today to tomorrow at 1pm est.
– Liam barry (@notesofbarry) (in reply to notesofbarry)07:44 – Aug 24, 2022
Converted to use QZBRMSEXIT and now my backups fail.
In version 4.5 we added the ability to better monitor BRMS backups by using a backup item exit program (WRKCTLGBRM, Opt 8) instead of a control group entry exit (WRKCTLGBRM, Opt 2, *EXIT). Often this results in surfacing errors previously ignored and thus the backup is reported as failed.
