RE: Retrieving numeric partition ID in SQL

Glad to have helped Dan.
MM


Respectfully,
Michael Mayer
IBM i on Power System Admin
INFOR LN Jr ERP Admin
ERMCO-ECI

ERMCO Power Igniter Award 2026
https://ermco-eci.awardco.com/feed/recognition/126539041

ibmireference.blogspot.com<http://ibmireference.blogspot.com>
2024 / 2025 / 2026 IBM Advocate, Contributor, Influencer.
2026 IBM "Bob" AI Badge.
2024 IBM i "Ready" Badge.
www.credly.com/users/michael-mayer.586da683/badges#credly<http://www.credly.com/users/michael-mayer.586da683/badges#credly>


________________________________

   2. RE: Retrieving numeric partition ID in SQL
      (Dan Bale via MIDRANGE-L)

------------------------------

message: 2
date: Thu, 30 Jul 2026 18:48:11 +0000
from: Dan Bale via MIDRANGE-L <[email protected]>
subject: RE: Retrieving numeric partition ID in SQL

Well, bloody hell.  I coulda sworn I looked at QSYS2.SYSTEM_STATUS_INFO before and didn't find the partition ID.  I knew it had the partition name, but ...

<sigh>

This sure beats the other technique I posted several minutes ago on simplicity!  Thanks Michael!

- Dan Bale

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> On Behalf Of Michael Mayer via MIDRANGE-L
Sent: Thursday, July 30, 2026 8:59 AM
To: [email protected]
Cc: Michael Mayer <michael.mayer-Cdy/[email protected]>
Subject: Retrieving numeric partition ID in SQL

Dan, try this .... I think this gets you what you want.
If not - I tried!
MM

SELECT
  (SELECT VARCHAR(CURRENT_CHARACTER_VALUE, 10)
   FROM QSYS2.SYSTEM_VALUE_INFO
   WHERE SYSTEM_VALUE_NAME = 'QSRLNBR') AS SERIAL_NUMBER,

  (SELECT VARCHAR(CURRENT_CHARACTER_VALUE, 10)
   FROM QSYS2.SYSTEM_VALUE_INFO
   WHERE SYSTEM_VALUE_NAME = 'QMODEL') AS SYSTEM_MODEL,

  (SELECT VARCHAR(CURRENT_CHARACTER_VALUE, 10)
   FROM QSYS2.SYSTEM_VALUE_INFO
   WHERE SYSTEM_VALUE_NAME = 'QPRCFEAT') AS PROCESSOR_FEATURE,

  PARTITION_ID
   FROM QSYS2.SYSTEM_STATUS_INFO;

Respectfully,
Michael Mayer
IBM i on Power System Admin
INFOR LN Jr ERP Admin
ERMCO-ECI

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.

You can help support midrange.com by visiting https://donate.midrange.com and making a contribution.