User Tools

Site Tools


aix:vios_cmdb_advanced

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)
aix/vios_cmdb_advanced.txt · Last modified: 2021/01/01 21:24 (external edit)