![Cloudberry server maintenance expired](https://kumkoniak.com/78.jpg)
WHERE EXPIR_DATE BETWEEN (CURRENT_DATE - 30 DAYS)
![cloudberry server maintenance expired cloudberry server maintenance expired](https://2.bp.blogspot.com/-KpfZH7ZIj2Y/VdnPwCogIJI/AAAAAAAACrk/IqIMYcDm3Xg/s1600/Cloudberry%2B4.png)
I can modify the SQL Select I used above to become to: But what about any products I have that will expire in the next year? P05 PSF for IBM i 1-55 IPM Printer SupportĪs the example results above have an expiration date, column EXPIRES, of null these products do not expire. INSTALLED EXPIRES GRACE LICPGM LIC_TERM RLS_LVL FEATURE I have to use a CAST with the LABEL column as it is in CCSID 1200, and the IBM i I am using uses CCSID 37.
![cloudberry server maintenance expired cloudberry server maintenance expired](https://help.msp360.com/content/images/buy_maintenance.png)
I renamed some of the columns, using the AS, to reduce the "width" of the results shown below. LICPGM,LIC_TERM,RLS_LVL,FEATURE,PROC_GROUP AS PROC_GRP,ĬAST(LABEL AS VARCHAR(100) CCSID 37) AS DESCRIPTION SELECT INSTALLED,EXPIR_DATE AS EXPIRES,GRACE_PRD AS GRACE, If I put that in a SQL select statement I can see all licensed products with their expiration dates. Version, release, and modification of the product Indicates whether the authorization exists until the next version, release, or modification level If null there is no grace period or the grace period has passed Indicates if the feature is installed or not I am only going to describe the ones I use, and refer you to the IBM documentation, whose link I give at the bottom of this post. This View contains more fields than I would use. The new View LICENSE_INFO, in library QSYS2, allows me to perform this check in one step, just with a simple SQL statement. I would always use DSPLICKEY to create the output file, that I would then check the license expiration dates to ensure I renewed any licenses before they expire.
![cloudberry server maintenance expired cloudberry server maintenance expired](https://kb.msp360.com/content/images/163a0387-1b46-41c0-b7d5-9db098c68c4d.png)
If I wanted to see which licensed products were installed I could just use the DSPLICKEY to produce an output file I could then view with Query or SQL.ĭSPLICKEY OUTPUT(*LICKEYFILE) I use any licensed products I need to be aware of when the license expires. I have always been able to see the license information on the IBM i I am on by using the Display License Key Info command, DSPLICKEY. It is all standard stuff to prevent the distribution of unauthorized software. I know of several third party IBM i software vendors who also use this method to stop the unauthorized copying of their software to unlicensed servers. IBM uses Software License Keys with certain IBM i products to ensure that I have paid the appropriate license fees to use these products on an IBM i.
![cloudberry server maintenance expired cloudberry server maintenance expired](https://kb.msp360.com/content/images/87ce7385-cc13-4b46-9168-22ea7263edc8.png)
Included in the latest Technical Refreshes for IBM i 7.3 and 7.2 is a SQL View and Procedure to help us monitor the licenses of the software on our IBM i.
![Cloudberry server maintenance expired](https://kumkoniak.com/78.jpg)