As the beating heart of the IBM i platform, the Db2 for i database received its share of attending from Rochester for the Spring 2023 Technology Refresh. Among the goodness becoming available next week are enhancements to the database proper as well as a gaggle of new and improved IBM i services.
One database enhancement common to both IBM i 7.5 TR2 and 7.4 TR8 is an improvement to SQL-based Web services using specific data types. The database and its SQL dialect already supported working with character large object (CLOBs) from the SQL HTTP REST functions, and provided commands for …
The post What the Spring 2023 TR Brings Db2 for i appeared first on IT Jungle. Read More
New columns added to HISTORY_LOG_INFO Simon Hutchinson
As part of the latest round of Technology Refreshes, IBM i 7.5 TR1 and 7.4 TR7, three new columns were added to one of my favorites Db2 for i Table Functions, HISTORY_LOG_INFO. I often use this Table Function to search the IBM i partitions’ history.
The new columns are all parts of the existing job name column, FROM_JOB:
FROM_JOB_NAME: Job name
FROM_JOB_USER: The user profile of the job
FROM_JOB_NUMBER: Job number
These columns might not sound like a big addition to HISTORY_LOG_INFO, but the first two, name and user, make it easier to find results I am looking for.
Read more » Read More
An Update On Power From POWERUp 2023 Timothy Prickett Morgan
After so many years of not normal, it is comforting to do something to feel normal, like travel to what be the COMMON spring user conference and what is now called POWERUp, and in particular POWERUp 2023. (I am only using the official capitalization there because Jenny will change it during edit if I don’t.) I don’t want to leave the hill I live on, especially after so many years of traveling many times a month, but I must say that I enjoyed myself and had my share of boisterous conversations, beer, and food.
And work, of course. For those …
The post An Update On Power From POWERUp 2023 appeared first on IT Jungle. Read More
IBM i at 35: A Walk Down Memory Lane Alex Woodie
You may have heard that the IBM midrange platform is turning 35 this year. IBM has a number of events planned in honor of that milestone, culminating with a big birthday bash on June 21. IBM execs gave us a sneak peak of the festivities to come at this week’s POWERUp show in Denver, as well as a technical look back at exactly how we got here.
The day the AS/400 launched in 1988 was notable for several reasons. IBM i CTO Steve Will, who was just starting his distinguished engineering career at IBM, recalls lots of excitement in the …
The post IBM i at 35: A Walk Down Memory Lane appeared first on IT Jungle. Read More
Supporting Your Casino Management System’s Custom IBM i Code Bill Onion
It’s not uncommon for teams to make customizations to their casino management system, whether for running specific reports or maintaining corporate standards. But what happens if the in-house developer who managed that code is no longer available? Whether they exited the company or moved into a new role, you’re left without support for your customized casino management system code. So, where do you turn? Read More
