Warning :- The main SQL statement may run for many minutes. In my case just over 1:30 elapsed and 35 CPU seconds, but I only have 222,000 objects in my IFS on a Power 9. I have run the QSRSRV (see below) on a Power 7+ with around a million objects in the IFS and […]
The world is complex enough as it is without IT. That is why I have taken it upon myself to explain what AutoDBE is used for on an IBM i system, so everyone can understand it. Please read this article and let me know if I have succeeded in doing so.
Hi. I’ve been able to get a hold of the OS/400 system images. Yay.
One problem, I don’t have an AS/400 computer. I have a 5250 emulator, but that is really useless without a server. I know that 400 and 390 are both PPC related and are very similar. Is it possible to emulate this? I’ve been thinking of modding Hercules to try and emulate the i PPC architecture. If there is an emulator out there, I would appreciate it if you directed me to it.
I was tired of “defending” the platform against people who doesn’t know anything about IBM i but still tells the world loudly and clear it is a old fashioned and dying platform.
Well, sometimes the best defense is a good offense. So i created a presentation where I instead of avoid talking about 5250 green screens from an end user perspective (where it honestly doesn’t belong), to highlighting unique features that other platforms just dreams about from a systems management perspective (massive help functions built in, unique in it’s message id system for problem detection and determination etc. etc.).
In the presentation I will go through as many things that is unique compared to other platforms I can in the time set aside for me. Could be unique in a way that there is nothing compared on other platforms at all (why do we have 520-byte format on storage, what is branching that makes IBM i ultra efficient and extremely fast for business applications?), but It can also be how something is implemented and often beautifully holistic integrated in the whole stack, from hardware and up to the data itself in the database (Tags Active Mode for example or how the database engine works extremely close to the CPU itself through Systems Licensed Internal Code).
And yes, I will also make some mocking about failed projects by other companies trying to build something similar to IBM i.
And yes, Intel and Sun will have their shared part…
Please reach out if you are interested in this session
Follow the instructions – enter your full name and email ID – for more information click here
Speaker: Doug Mack, Analytics Consultant, Db2 for i, IBM Systems Lab Services
Every BI/Analytics vendor shows you fancy visualization screens (including IBM) but not talk about where the real work is in making a BI/Analytics project successful. Most BI pundits say up to 70% of the work is in wrangling the data. Get that right, and the reporting/analytics becomes much simpler and efficient. Db2 Web Query contains multiple ways to wrangle your data while leveraging what you already have with RPG, SQL, or even Query/400. In this session we delve into use of Synonyms to describe your data, leveraging SQL when appropriate, and facilities to create data flows or ETL processes to cobble data together for your analytics projects. Many how-to demos will be included.