ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to reorganize PostGresQL indexes on JMO r11.2?


Article ID: 53302


Updated On:


Compress Data Compression for MVS Compress Data Compression for Fujitsu Unicenter Job Management Option CA Unicenter NSM



On NSM 3.x versions a utility called 'cashrcvr' can be used to reorganize the CADB indexes in tablespace CAICA7DB.
Which utility can we use to reorganize the JMO r11.2 PostGresQL tables?


You can find under $PGSQL_HOME/bin a binary called 'reindexdb'.

If you execute 'reindexdb --help' you get following response which details the usage of the utility as an explanation of possible options

 # reindexdb --help
reindexdb reindexes a PostgreSQL database.
  reindexdb [OPTION]... [DBNAME]
  -a, --all                 reindex all databases
  -s, --system              reindex system catalogs
  -d, --dbname=DBNAME       database to reindex
  -t, --table=TABLE         reindex specific table only
  -i, --index=INDEX         recreate specific index only
  -e, --echo                show the commands being sent to the server
  -q, --quiet               don't write any messages
  --help                    show this help, then exit
  --version                 output version information, then exit
Connection options:
  -h, --host=HOSTNAME       database server host or socket directory
  -p, --port=PORT           database server port
  -U, --username=USERNAME   user name to connect as
  -W, --password            prompt for password

Read the description of the SQL command REINDEX for details.

Report bugs to <[email protected]>.


Release: UWSMWL55500-11.2-Network and Systems Management-Job Management Option