Blog

Posted on

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

Posted on

Daily news about IBM AIX

AIX Stuff

  • Meridian IT launches two new Private IBM Power Cloud services for APAC – CRN Australia
    on 2024-10-15 at 14:43

    Meridian IT Australia has launched two new Private IBM Power Cloud facilities and new security offerings in Sydney and Melbourne, the company said. “The launch of our private IBM Power cloud services will enable us to support legacy systems as well as newer IBM environments from highly customisable Private or Hybrid cloud environments designed and built for how our customers want to leverage the Cloud,” Matt Powell, Meridian’s regional vice president, said.

  • What do we expect from IBM Power11?
    by albamart on 2024-10-15 at 11:54

    The evolution of IBM’s Power architecture has been the subject of intense debate in the technology community. Over the past few years, this architecture has undergone significant strategic changes that have generated criticism and expectations alike. As with KVM, we almost guessed everything IBM was going to announce; let’s take a second shot at Power11.

  • Revolutionize Your IT Infrastructure with IBM Power Virtual Server
    by Paul Chapman on 2024-10-15 at 06:32

    Discover IBM Power Virtual Server Private Cloud. Learn about on-premises managed infrastructure, flexible pricing, and hybrid cloud capabilities.

  • PowerHA SystemMirror for AIX Archives
    on 2024-10-15 at 05:10

    October 14, 2024 Timothy Prickett Morgan If there are Technology Refreshes for the IBM i stack and new Technology Levels for AIX, then that means IBM has also updated a slew of systems software and middleware that runs atop these stacks. This being the fall, then we knew that TRs were coming for IBM and we therefore knew that updates were coming for PowerVM, VIOS, PowerVC, Cloud Management Console, and the Hardware Management Console. The enhancements for these collections of software were part of the October 8 announcements, were detailed in announcement letter AD24-0630, and will be available for electronic download on December 12 this … Read more

  • Sundry Hardware Announcements Accompany IBM i TR Updates
    by Timothy Prickett Morgan on 2024-10-14 at 04:10

    With high-end Power10 machines coming out in September 2021 and most of the Power10 lineup coming in July 2022, we don’t expect much in the way of substantial Power10 system announcement at this point in that processor’s lifecycle. The “Bonnell” entry Power S1012 machine from this year May is, in fact, probably the last Power10 machine to come out the door until Power11 systems come out next year some time. But IBM is always tweaking things here and there when it comes to hardware features and bundles, and so it is with the October IBM i platform updates. We saw … The post Sundry Hardware Announcements Accompany IBM i TR Updates appeared first on IT Jungle.

Posted on

Displaying foreign key constraints using SQL

foreign key information using sql

I was asked:

What about referenced tables when you specify a foreign key when creating a table? I can check this when I run DSPFD, it is in Parent File Description but I still can’t find an SQL to elaborate all tables in our Application.

I have to admit this one took me some time to find the information I need to provide the example in this post.

A foreign key is one of the many constraints that can be used with Db2 for i tables and DDS files. Doing a quick search of the IBM KnowledgeCenter I found the following:

  • SYSCST:  Every constraint, can be considered the “header” file for constraints
  • SYSCSTCOL:  Columns upon which the constraints have been defined
  • SYSCSTDEP:  Tables upon which the constrains have been defined
  • SYSKEYCST:  Every unique, primary, and foreign key that has been defined
  • SYSREFCST:  Foreign keys that have been defined

Read more »

Verified by MonsterInsights