infx management suite

Search this site
command line‎ > ‎

instance

infx start|stop|mode|inst

Manage informix database instances, start up , shutdown, and other instance management tasks.

 cmd   description
 start  start database server
 stop  stop database server
 mode  change instance mode
 photo record current instance information 
 dbphoto record current database information 
 inst new  create a new instance
 inst rm  remove an instance
 inst init  complete disk initialization
 inst idir  change informix software
 inst idirrm  remove informix software
 inst ialias  assign software alias
 inst ialiaschg  change software alias

start database server

infx start fork=no

Start the database server for this instance. If start up takes too long, the service will return while start up continues. To have
the service wait until start up is complete, specify fork=no

stop database server

infx stop fork=no

Shutdown the database server for this instance. If shutdown takes too long, the service will return while shutdown continues. To have
the service wait until shutdown is complete, specify fork=no

change instance mode

infx mode mode=qmode|quiescent|smode|singleuser|omode|online

Change the operating mode of the database server.

photo

Store the current information about the instance. Includes all onstat information, spaces, chunk files etc.

infx photo

You can optionally pass a parameter, res=, to specify how much detailed information you want. The higher the "res", the more space the disk files will take up.

 res excluded 
 low user session information (from sysmaster), detailed lock information (onstat -k) and detailed sql history
 information (onstat -g his)		 
 med detailed sql history information (onstat -g his)   
 high     nothing 

These files can be passed as parameters to the infx status command line service and dashboards to view the historical information.

dbphoto

Store the current information about databases. Includes information from sysmaster such as sysptprof and systabnames.

infx dbphoto

You can optionally pass a parameter, res=, to specify how much detailed information you want. The higher the "res", the more space the disk files will take up.

 res excluded 
 low partition list (breakdown of table by index and partition) 
 high     nothing 

By default, this service dumps information about all databases. 

In config.ini, you can override that by setting the parameter INFX_PHOTO_DBS to the list of databases you want to dump.

You can optionally specify a database name, or list of databases from the command line.

e.g. dump all databases

infx dbphoto

e.,g. dump one database

infx dbphoto db=monitor_jgh1

e.g. dump two databases

infx dbphoto db=monitor_jgh1+bartest

The output of these "photos" can be passed as parameters to the infx status command line service and dashboards to view the historical information.

instance management

infx inst func=new|init|idir|rm newinst= idir= [ config onconfig servernum sw squiggle | fork=no

Create and manage database instances

 func
  description
 new     new - create a new instance
 init  init - do complete disk initialization of the instance
 idir  idir - change the informix software for an instance
 rm  rm - remove all files for an instance

create a new instance

infx inst func=new [ config onconfig servernum sw ] fork=no

Create a new instance of the database server.

 option
  description

  example
 config  instance config template to use, default=inst-config  config=infx-config.inst
 onconfig  instance onconfig template to use, default=infx-small  onconfig=newonconfig
 servernum  unique number to assign this instance on this host, defaults to next available  servernum=5
 sw   specify a specific version of the informix sw to use  sw=IIF_11.50FC7DE

Creates all of the files, directories and links required for an instance of the database. See config/onconfig for format details.

You can re-run the creation on an existing instance, to update its configuration. Only new files, directories and links will be created.
All existing ones are retained. A new ONCONFIG file will not be generated when one already exists.

Specify an absolute path for the sw parameter, or spcify the path relative to /infx/sw.

Does not initialize the database instance, just creates files etc.

remove an existing instance

infx inst func=rm

Remove all of the files, directories and links for this instance. The instance must already be offline, and all chunks files already
removed before this service can run.

initialize an instance

infx inst func=init squiggle=yes fork=no

Create a new instance of the database server.

 option
  description

  example
 squiggle  you must enter squiggle=yes  squiggle=yes
 fork  specify fork=no to have service wait until initialization is complete  fork=no

Performs a complete database disk initialization. You must shutdown the database instance, and remove all chunk files before
you can run this.

change informix software

infx inst func=idir sw=

Create a new instance of the database server.

 option
  description

  example
 sw  specify a specific version of the informix software to use  sw=IIF_11.50FC7DE

Change the version of the informix software for this instance. The instance must be offline for this service to run. You must ensure
that a valid ONCONFIG and SQLHOSTS file for the instance exists in the new software directory.

Always read the documentation, test the new version and backup for data and config files before changing informix software versions.

Specify an absolute path for the sw parameter, or specify the path relative to /infx/sw.

remove informix software

infx inst func=idirrm sw=

Remove a version of the informix software when you no longer need it. 

 option
  description

  example
 sw  specify a specific version of the informix software to remove sw=IIF_11.50FC7DE

create an alias for informix software

infx inst func=ialias alias= sw=

Defined an alias for a specific version of informix software. 

 option
  description

  example
 alias  the name of the alias  alias=latest
 sw  specify a specific version of the informix software to remove sw=IIF_11.50FC7DE

example

infx inst func=ialias alias=latest sw=IIF_11.50FC7DE

When you specify the software for an instance, you can use the alias instead of the version number. Later, if you upgrade, all
instances pointing to that alias can be upgraded at once.

change an informix software alias

infx inst func=ialiaschg alias= sw=

Change the specific version of the informix software that an alias points to.

 option
  description

  example
 alias  the name of the alias  alias=latest
 sw  specify a specific version of the informix software to remove sw=IIF_11.50FC7DE

example

infx inst func=ialiaschg alias=latest sw=IIF_11.50FC8DE

All of the instances that are using this alias must be shutdown before this service can run. You must also make sure that the
new software directory contains valid ONCONFIG and SQLHOSTS files for all instances.

Sign in|Report Abuse|Print Page|Remove Access|Powered By Google Sites