Visit Our UNIX and Linux User Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

capture-schema(1m) [sunos man page]

capture-schema(1m)					    Application Server Utility						capture-schema(1m)

NAME
capture-schema - stores the database metadata (schema) in a file for use in mapping and execution SYNOPSIS
capture-schema-dburl url-username name- password password-driver a_jdbc_driver [-schemaname name] [-table tablename]* [-out filename] Stores the database metadata (schema) in a file. You can also use the Sun Java System Studio IDE to capture the database schema. Run cap- ture-schema as the same database user that owns the tables, so that the -username and -schemaname options are given the same username. Additionally, you can grant the database user running the capture-schema command the ANALYZE ANY TABLE privilege. OPTIONS
-dburl JDBC URL expected by the driver for accessing a database. -username user name for authenticating access to a database. -password password for accessing the selected database. -driver JDBC driver classname in your CLASSPATH. -schemaname name of the user schema being captured. If not specified, the default will capture metadata for all tables from all the schemas accessible to this user. Specifying this parameter is highly recommended. If more than one schema is accessible to this user, more than one table with the same name may be captured which will cause problems. -table name of the table; multiple table names can be specified. -out output target; defaults to stdout. This parameter corresponds to the schema sub-element of the sun-cmp-mapping ele- ment in the sun-cmp-mapping_1_1.dtd file. EXAMPLES
Example 1: Using capture-schema capture-schema -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817 -schemaname cantiflas -username CANTIFLAS -password enigma -driver oracle.jdbc.driver.OracleDriver asadmin(1M) Sun Java System Application Server March 2004 capture-schema(1m)

Check Out this Related Man Page

imqdbmgr(1M)						  System Administration Commands					      imqdbmgr(1M)

NAME
imqdbmgr - manage a plugged-in JDBC-compliant Message Queue data store SYNOPSIS
/usr/bin/imqdbmgr subcommand argument [ [option...]] /usr/bin/imqdbmgr -h | -help /usr/bin/imqdbmgr -v | -version DESCRIPTION
The imqdbmgr utility creates and manages a Java DataBase Connectivity (JDBC) compliant database used for Message Queue persistent storage. The database can be either embedded or external. To use a JDBC-compliant database (and the imdbmgr utility), you need to first set a number of JDBC-related properties in the broker instance configuration file. See the Sun Java System Message Queue Administrator's Guide for addi- tional information. imqdbmgr supports four management subcommands. These subcommands, and their corresponding arguments and options follow the imqdbmgr command on the command line. See USAGE and OPTIONS. The following subcommands are supported: create Create a Message Queue database schema. delete Delete Message Queue database tables in the current data store. recreate Delete Message Queue database tables and recreate Message Queue database schema in the curent data store. reset Reset the database table lock to allow other processes to access database tables. The imqdbmgr subcommands support the following arguments: all Indicates the subcommand applies to the data store, as well as the database tables. lck Indicates the subcommand applies to the database table lock. oldtbl Indicates the subcommand applies to an older version of the database tables. tbl Indicates the subcommand applies to the database tables only. OPTIONS
The following options are supported: -b brokerName Specify the broker instance name and corresponding instance configuration properties. If this option is not specified, the default broker instance is assumed. Use this option with the create, delete, recreate, or reset subcommands. -D property=value Set system property property to value. Use this option with the create, delete, recreate, or reset subcommands. -h | -help Display usage help. Execute nothing else on the command line. -p password Specify the database password. Use this option with the create, delete, recreate, or reset subcommands. -u userName Specify the database user name. Use this option with the create, delete, recreate, or reset subcommands. -v | -version Display version information. Execute nothing else on the command line. USAGE
The following subcommands and associated arguments are supported: create all Create a new embedded data store and Message Queue database schema for a specified or default broker instance. create tbl [-u userName] [-p password] Create Message Queue database schema in an existing data store for a specified or default broker instance. delete tbl [-u userName] [-p password] Delete Message Queue database tables in the current data store for a specified or default broker instance. delete oldtbl [-u userName] [-p password] Delete the earlier version of Message Queue database tables. Used after the data store has been automatically migrated to the current version of Message Queue. recreate tbl [-u userName] [-p password] Delete Message Queue database tables and recreate Message Queue database schema in the current data store for a specified or default broker instance. reset lck Reset the database table lock to allow other processes to access database tables. ENVIRONMENT VARIABLES
The following environment variables affect the execution of this command: IMQ_JAVAHOME Specify the Java 2 compatible runtime. When this environment variable is not set it defaults to /usr/j2se. EXIT STATUS
The following exit values are returned: 0 Successful completion. >0 An error occurred. FILES
/var/imq/instances/brokerName/dbstore Recommended directory in which to create an embedded database. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWiqu | +-----------------------------+-----------------------------+ SEE ALSO
imqadmin(1M), imqbrokerd(1M), imqcmd(1M), imqusermgr(1M), imqkeytool(1M), imqobjmgr(1M), attributes(5) Sun Java System Message Queue Administrator's Guide SunOS 5.11 29 Mar 2004 imqdbmgr(1M)

Featured Tech Videos