aDriv4 - MANAGER

Edit File: sapnw.py

# This file is part of the sos project: https://github.com/sosreport/sos
#
# This copyrighted material is made available to anyone wishing to use,
# modify, copy, or redistribute it subject to the terms and conditions of
# version 2 of the GNU General Public License.
#
# See the LICENSE file in the source distribution for further information.

from sos.report.plugins import Plugin, RedHatPlugin

class Sapnw(Plugin, RedHatPlugin):

short_desc = 'SAP NetWeaver'
    plugin_name = 'sapnw'
    profiles = ('sap',)
    files = ('/usr/sap',)

def collect_list_instances(self):
        """ Collect data on installed instances """
        inst_list = self.collect_cmd_output(
            "/usr/sap/hostctrl/exe/saphostctrl -function ListInstances",
            suggest_filename="SAPInstances"
        )
        if inst_list['status'] != 0:
            return

sidsunique = set()
        # Cycle through all the instances, get 'sid', 'instance_number'
        # and 'vhost' to determine the proper profile
        for inst_line in inst_list['output'].splitlines():
            if ("DAA" not in inst_line and not
                    inst_line.startswith("No instances found")):
                fields = inst_line.strip().split()
                if len(fields) < 8:
                    continue
                sid = fields[3]
                inst = fields[5]
                vhost = fields[7]
                sidsunique.add(sid)
                path = f"/usr/sap/{sid}/SYS/profile/"
                if not self.path_exists(path):
                    continue
                for line in self.listdir(path):
                    if all(f in line for f in [sid, inst, vhost]):
                        ldenv = f'LD_LIBRARY_PATH=/usr/sap/{sid}/SYS/exe/run'
                        # Unicode is assumed here
                        # nuc should be accounted
                        path = f'/usr/sap/{sid}/SYS/exe/uc/linuxx86_64'
                        profile = line.strip()

# collect profiles
                        self.add_cmd_output(
                            f"env -i {ldenv} {path}/sappfpar all "
                            f"pf=/usr/sap/{sid}/SYS/profile/{profile}",
                            suggest_filename=f"{profile}_parameters"
                        )

# collect instance status
                        self.add_cmd_output(
                            f"env -i {ldenv} {path}/sapcontrol -nr {inst} "
                            "-function GetProcessList",
                            suggest_filename=f"{sid}_{inst}_GetProcList"
                        )

# collect version info for the various components
                        self.add_cmd_output(
                            f"env -i {ldenv} {path}/sapcontrol -nr {inst} "
                            "-function GetVersionInfo",
                            suggest_filename=f"{sid}_{inst}_GetVersInfo"
                        )

# collect <SID>adm user environment
                        lowsid = sid.lower()
                        fname = f"{sid}_{lowsid}adm_{inst}_userenv"
                        self.add_cmd_output(
                            f'su - {lowsid}adm -c "sapcontrol -nr {inst} '
                            '-function GetEnvironment"',
                            suggest_filename=fname
                        )

# traverse the sids list, collecting info about dbclient
        for sid in sidsunique:
            self.add_copy_spec(f"/usr/sap/{sid}/*DVEB*/work/dev_w0")

def collect_list_dbs(self):
        """ Collect data all the installed DBs """
        # list installed sap dbs
        db_list = self.collect_cmd_output(
            "/usr/sap/hostctrl/exe/saphostctrl -function ListDatabases",
            suggest_filename="SAPDatabases"
        )

if db_list['status'] != 0:
            return

for line in db_list['output'].splitlines():
            if "Instance name" in line:
                fields = line.strip().split()
                dbadm = fields[2][:-1]
                dbtype = fields[8][:-1]
                sid = dbadm[3:].upper()

if dbtype == 'db6':
                    # IBM DB2
                    self.add_cmd_output(
                        f"su - {dbadm} -c \"db2 get dbm cfg\"",
                        suggest_filename=f"{sid}_{dbadm}_db2_info"
                    )

elif dbtype == 'sap':
                    # SAP MAXDB
                    sid = fields[2][:-1]
                    self.add_copy_spec(
                        f"/sapdb/{sid}/data/config/{sid}.pah"
                    )

elif dbtype == 'ora':
                    # Oracle
                    sid = fields[2][:-1]
                    self.add_copy_spec(f"/oracle/{sid}/*/dbs/init.ora")

elif dbtype == 'syb':
                    # Sybase
                    sid = fields[2][:-1]
                    self.add_copy_spec(f"/sybase/{sid}/ASE*/{sid}.cfg")

def setup(self):
        self.collect_list_instances()
        self.collect_list_dbs()

# vim: et ts=4 sw=4