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
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)