Having Expiration Dates After 12/31/2038 in BRMS

In releases IBM i 7.2 and later, BRMS supports creating media with an expiration date between 1990-2089. 

In releases IBM i 7.1 and earlier, BRMS does not support creating media with an expiration date after 12/31/2038. 

Media policies can be setup with a Retention type in days for up to 9,999 days.  This can cause an expiration date that is after 12/31/2038.  In this case, since BRMS does not allow expiration dates after 12/31/2038, BRMS will convert the expiration date to *PERM.

Structured Query Language (SQL) can be used to help determine which volumes have an expiration date set to *PERM but should be expired. Warning, this method should only be used for BRMS environments that do not otherwise use *PERM for media expiration. To find all *PERM volumes that should expire after 12/31/2038, run this SQL select statement:

SELECT TMCVSR, TMCCRT, TMCEXP FROM QUSRBRM/QA1AMM WHERE TMCCRT < 'CYYMMDD' AND TMCCRT <> '0000000' AND TMCEXP = '9999999' ORDER BY TMCCRT ASC

For example, to find all expired volumes that have *PERM expiration dates and are more than 25 years old (assuming the current date is 6/26/2039), run this select:

SELECT TMCVSR, TMCCRT, TMCEXP FROM QUSRBRM/QA1AMM WHERE TMCCRT < '1140626' AND TMCCRT <> '0000000' AND TMCEXP = '9999999' ORDER BY TMCCRT ASC

Notes:

• In releases IBM i 7.1 or earlier, the following PTFs or their superseding PTFs are required:

7.1 SI43868
6.1 SI43869
5.4 SI43862

Notes:

1. The Change Media using BRM (CHGMEDBRM) command, the Work Media using BRM (WRKMEDBRM) command with option 2 or the Work with Media Information (WRKMEDIBRM) command with option 2 can be used to change the expiration date of media or media information to dates after 2038.  In releases IBM i 7.1 and 6.1, expiration dates specified after 2038 will be changed to *PERM. The following PTFs or superseding PTFs are required:

7.2 SI54787
7.1 SI54786
6.1 SI54702