RE: System name via SQL

I'd say the system name (Really a holdover from SNA since it's only 8
characters) and the database name are different on 80% of the systems we
support, and there are multiple database entries on most machines. That's
driven by HA and other systems attaching to DB2.

I think a system service to retrieve all of the network attributes would be
fabulous. My vote would be to put it into the QSYS2.SYSTEM_STATUS_INFO
but anywhere would be OK.


--
Jim Oberholtzer
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Berendt
Sent: Friday, August 03, 2018 7:34 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: System name via SQL

I too was going to suggest
SELECT host_name FROM QSYS2.SYSTEM_STATUS_INFO;

But, just like those who aren't used to anyone not having their local
database name set to their system name, I was unused to anyone not having
DSPNETA set to the same name as that shown in CHGTCPDMN<F4>.

"What, you mean your system console is not DSP01?" kind of thing.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail
to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Steve Pitcher" <SPitcher@xxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: 08/02/2018 08:28 PM
Subject: System name via SQL
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Developer gurus: a challenge! How would you get the system name of a
partition via an SQL statement? Not the host name or domain name. The
system name from DSPNETA.

Steven Pitcher
IBM i and Power Systems Expert

iTech Solutions Group<https://www.itechsol.com/>
39 Parkview Drive, New Glasgow, NS B2H0E6
Mobile: (902) 301-0810
Email: spitcher@xxxxxxxxxxxx<mailto:spitcher@xxxxxxxxxxxx>
[ibm-champion-rgb-175px (1)]