PowerVUG – Session 107: Turning data into Information with Db2 Web Query for IBM i

  • 9 June 2021, 14:00-15:30 UK time (BST)
  • 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.
  • Relevant for IBM i environments.

PowerVUG – Session 106: VIOS – Top Tips for Successful Administration

  • 19 May 2021, 14:00-15:30 UK time (BST)
  • Speaker: Jaqui Lynch, Information Architect, AIX & Linux® Performance Consultant, IBM Power Champion
  • VIO servers are the most critical part of your system setup.  If they are not happy, then no client LPAR is happy. This session provides tips on setting up and maintaining VIO servers including upgrades and patching.  Backup and recovery are also covered.
  • Relevant for AIX, IBM i, and Linux® environments.

External Events – Power Virtual User Group

Session 105: Everything You Need to Know About IBM i Administration Runtime Expert

  • 21 April 2021, 14:00-15:30 UK time (BST)
  • Speaker: Dawn May, IBM i Consultant, and Technical Expert
  • Business-critical applications must be up and running reliably without failure. When something unexpected occurs, you must identify the cause and correct it quickly. We all want to find ways to make our jobs easier, and unexpected surprises are not fun. The relentless push to do “more with less” is going to intensify while the tolerance for failure keeps dropping.  Yet identifying points of failure can be tricky as complexities scale.IBM i offers a free product that helps ascertain application and infrastructure health. The IBM Administration Runtime Expert for i (ARE) can be used to define attributes of a healthy environment and use those defined attributes to validate that the environment is as expected.  This session covers everything you need to know about ARE, including examples such as:
    • Ensure a test environment is the same as production for software installed and object levels
    • Identify what changed to cause an unexpected application failure
    • Validate multiple partitions are consistent in their configurations
    • Verify user profiles are consistent across all partitions
    • Check that PTF levels are the same across all partitions for a particular release
    • Create custom plug-ins to extend the base ARE functionality
  • Relevant for IBM i environments

Daily news about IBM AIX

  • Docker-like containers on AIX
    by Power DevOps on 2025-03-31 at 19:25

    #IBMAIX has a technology called WPAR to enable containerization, but it is not developer-friendly like podman or docker.3 years ago, I did a small PoC – runc-aix to run containers on AIX in a “runc manner”. It is based on WPAR syscalls that are available in AIX, but it doesn’t use any userspace WPAR tools. It can start and stop containers and nothing else.This is a small demo using it.

  • AIX Toolbox – What is hidden among the RPM packages for AIX?
    by Kamil Pytliński on 2025-03-29 at 22:23

    Most of us working with AIX know the IBM AIX Toolbox for Open Source Software. It’s a repository that gives us access to the open-source world. But have you ever looked closely… The post AIX Toolbox – What is hidden among the RPM packages for AIX? appeared first on OSAdmins.

  • IBM! I am tired to hear the word “OpenShift”! Is there anything better?
    on 2025-03-28 at 12:04

    Why should I pay so many bucks for the opensource software?

  • AIX 7.2 on QEMU, virtio drivers
    by krackout21 on 2025-03-25 at 05:42

    I’m also trying to switch from spapr-vscsi & spapr-vlan devices to virtio. (There’s only one NIC on the vm, but have the same result with spapr-vlan enabled, in which case networking works fine)

  • perl binary on AIX shows relative paths in ldd output
    by tseeling on 2025-03-25 at 05:42

    If set to a static default like the offending (and imho insecure!) relative paths are no longer shown and works correctly. Update: I can block this behaviour by explicitly setting the variable which controls the order of searching and loading dynamic libraries (this is like on Linux).

Verified by MonsterInsights