DATA ANALYSIS TOOLS & IBM AIX - 1
As an AIX Power VM admin managing a large number of VMs, leveraging scripting, automation, and data analysis tools is essential for efficient maintenance and monitoring.These tools provide valuable insights into the operational health of the VMs.
Take errpt for example : The process begins with collecting data from the errpt of the past 24 hours using a simple AIX script (errpt.sh) with dsh (distributed shell) from the NIM server. After performing data cleaning and wrangling using awk,sed,cut... the output from all VMs is consolidated into a single CSV file.
The next step involves using a Python script (csv2xlsx.py) with Paramiko and Openpyxl to retrieve the CSV file from the NIM server and parse it into Excel spreadsheet with custom formatting such as headers, dates, and colors. This resulting xlsx output enables quick filtering through > 300 LPARs/VIOS errpt in just 20 sec.?
Furthermore, pivot tables can be employed to create errpt dashboards, or the CSV file can be imported to Microsoft Power BI for additional customization and monitoring.
This approach can be applied to various tasks including HMC service events, LPAR uptime, FCS WWN, network configurations (LPAR/ENT/SLOT/VLAN/IP/NETWORK/NIB..),LLDP or lsnports/scsi_id from VIOS, storage information (hdisk/size/lunid/VG/PVID/storage type)...Practically, any CSV file containing data from your AIX VMs or HMC can be transformed into valuable insights.
to download errpt.sh and csv2xls.py ( need some extra lib : openpyxl/glob/xlwings..) :? https://1drv.ms/f/s!AhNKUl-G7r1j0jfJ8_Vt4ucZ8pSC?e=5CtT1g
Senior IT Managing Consultant, IBM Power Systems Lead - IBM Platinum Redbooks Author
1 年Nice
Responsable Infrastructures & Systèmes Centraux AIX chez EURAFRIC INFORMATION
1 年Well done Oussama, very useful !