====== VIOS CMDB ======
===== Start CM DB =====
Manually start VIOS CMDB in case of trouble
[root@dcbv-vios02]/home/padmin# su - vpgadmin -c "/usr/ios/db/bin/postgres -D /home/ios/CM/DB"
[root@dcbv-vios02]/home/padmin# ps -ef | grep vpgadmin
vpgadmin 8192272 1 0 14:33:34 - 0:00 /usr/ios/db/bin/postgres -D /home/ios/CM/DB
vpgadmin 10420548 8192272 0 14:33:34 - 0:00 postgres: CM: logger process
vpgadmin 10486086 8192272 0 14:33:35 - 0:00 postgres: CM: checkpointer process
vpgadmin 10551622 8192272 0 14:33:35 - 0:00 postgres: CM: writer process
vpgadmin 10617160 8192272 0 14:33:35 - 0:00 postgres: CM: wal writer process
vpgadmin 10682698 8192272 0 14:33:35 - 0:00 postgres: CM: autovacuum launcher process
vpgadmin 10748236 8192272 0 14:33:35 - 0:00 postgres: CM: stats collector process
vpgadmin 10813774 8192272 0 14:33:35 - 0:00 postgres: CM: bgworker: logical replication launche
===== Get CM DB infos =====
As root user
Example of commands to list CMDB informations
[root@dcbv-vios01]/home/padmin# /usr/ios/db/bin/psql -U vpgadmin -l -p 6080 -P pager=off
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+-----------+----------+---------+-------+-----------------------
postgres | vpgadmin | LATIN1 | en_US | en_US |
template0 | vpgadmin | LATIN1 | en_US | en_US | =c/vpgadmin +
| | | | | vpgadmin=CTc/vpgadmin
template1 | vpgadmin | LATIN1 | en_US | en_US | =c/vpgadmin +
| | | | | vpgadmin=CTc/vpgadmin
vioscm | viosadmin | LATIN1 | en_US | en_US |
(4 rows)
[root@dcbv-vios01]/home/padmin# /usr/ios/db/bin/psql -U vpgadmin -d vioscm -p 6080 -P pager=off
psql (10.6)
Type "help" for help.
vioscm=#
vioscm=# \dn
List of schemas
Name | Owner
--------+-----------
public | vpgadmin
vioscm | viosadmin
viosdr | viosadmin
(3 rows)
vioscm=# \dt viosdr.*
List of relations
Schema | Name | Type | Owner
--------+----------------+-------+-----------
viosdr | client | table | viosadmin
viosdr | disk | table | viosadmin
viosdr | disk_mapping | table | viosadmin
viosdr | ds8k_disk | table | viosadmin
viosdr | hitachi_disk | table | viosadmin
viosdr | op_status | table | viosadmin
viosdr | svc_disk | table | viosadmin
viosdr | sys_disks | table | viosadmin
viosdr | vios_partition | table | viosadmin
viosdr | vmax_disk | table | viosadmin
viosdr | wwpn | table | viosadmin
viosdr | xiv_disk | table | viosadmin
(12 rows)
vioscm=# \dt vioscm.*
List of relations
Schema | Name | Type | Owner
--------+--------------------------------------+-------+-----------
vioscm | common_net_attr | table | viosadmin
vioscm | event | table | viosadmin
vioscm | event_attribute | table | viosadmin
vioscm | fc_interface | table | viosadmin
vioscm | fc_port | table | viosadmin
vioscm | interface | table | viosadmin
vioscm | io_port | table | viosadmin
vioscm | ip_address | table | viosadmin
vioscm | ipif | table | viosadmin
vioscm | iscsi_attr | table | viosadmin
vioscm | lhea_attr | table | viosadmin
vioscm | lnagg_attr | table | viosadmin
vioscm | logical_unit | table | viosadmin
vioscm | logical_volume | table | viosadmin
vioscm | map | table | viosadmin
vioscm | mass_storage | table | viosadmin
vioscm | net_dep | table | viosadmin
vioscm | net_map | table | viosadmin
vioscm | nic_attr | table | viosadmin
vioscm | object | table | viosadmin
vioscm | object_aux_cache | table | viosadmin
vioscm | old_device_map | table | viosadmin
vioscm | optical | table | viosadmin
vioscm | partition | table | viosadmin
vioscm | path | table | viosadmin
vioscm | pathdevice | table | viosadmin
vioscm | pending_delete | table | viosadmin
vioscm | physical_adapter | table | viosadmin
vioscm | pv | table | viosadmin
vioscm | resource | table | viosadmin
vioscm | sea_attr | table | viosadmin
vioscm | ssp_lu | table | viosadmin
vioscm | tape | table | viosadmin
vioscm | transaction | table | viosadmin
vioscm | vasi_adapter | table | viosadmin
vioscm | vasi_map | table | viosadmin
vioscm | vea_attr | table | viosadmin
vioscm | vf_attr | table | viosadmin
vioscm | vg_map | table | viosadmin
vioscm | virtual_fibre_channel_server_adapter | table | viosadmin
vioscm | virtual_server_adapter | table | viosadmin
vioscm | vlan_attr | table | viosadmin
vioscm | vnic_server_attr | table | viosadmin
vioscm | volume_group | table | viosadmin
vioscm | vrmpg_map | table | viosadmin
(45 rows)
vioscm=# set search_path to vioscm;
SET
vioscm=# select * from physical_adapter;
object_id | partition_id | location_code
-----------+--------------+--------------------------
2 | 1 | U78D3.001.WZS09X0-P1-C6
5 | 1 | U78D3.001.WZS09X0-P1-C7
8 | 1 | U78D3.001.WZS09X0-P1-C11
13 | 1 | U78D3.001.WZS09X0-P1-C49
15 | 1 | U9009.22A.7890360-V1-C2
17 | 1 | U9009.22A.7890360-V1-C3
(6 rows)