Set up an entry mapping repository, a property extension repository, or a custom registry database repository using wsadmin commands

Network Deployment (Distributed operating systems), v8.0 > Secure applications and their environment > Authenticate users > Select a registry or repository > Manage realms in a federated repository > Configure a property extension repository in a federated repository

Set up an entry mapping repository, a property extension repository, or a custom registry database repository using wsadmin commands

Overview

We can set up an entry mapping repository, a property extension repository, or a custom registry database repository using wsadmin commands.
If you are setting up an entry mapping repository, begin with the steps described in...

Configure an entry mapping repository in a federated repository

If you are setting up a property extension repository, begin with the steps described in...

Configure a property extension repository in a federated repository

When you create a repository, use the appropriate wsadmin commands to...

Define the database schema
Populate the database property definitions

Procedure

Create the database.

For DB2, open a DB2 command window or command center and enter the following:

db2 create database <name> using codeset UTF-8 territory US

Enter the following database tuning commands:

db2 update database configuration for <name> using applheapsz 1024
db2 update database configuration for <name> using stmtheap 4096
db2 update database configuration for <name> using app_ctl_heap_sz 2048
db2 update database configuration for <name> using locklist 1024
db2 update database configuration for <name> using indexrec RESTART
db2 update database configuration for <name> using logfilsiz 1000
db2 update database configuration for <name> using logprimary 12
db2 update database configuration for <name> using logsecond 10
db2 update database configuration for <name> using sortheap 2048
db2set DB2_RR_TO_RS=yes

Optional: For Informix databases using dbaccess...

CREATE DATABASE <name> WITH BUFFERED LOG

Optional: For Oracle databases, the database should already exist during Oracle installation (for example, orcl).

Run either...

setupIdMgrEntryMappingRepositoryTables.sh
setupIdMgrPropertyExtensionRepositoryTables.sh
setupIdMgrDBTables.sh (custom registry)

Use -file to specify full path to the file containing key=value pairs. If a parameter is specified on both the command line and in the file, the value on the command line takes precedence.

setupIdMgrDBTables.sh
Create and populate tables in the database. Arguments are case-sensitive.

schemaLocation Location of WAS_HOME/etc/wim/setup
dbPropXML Location of database repository property definition XML file.
databaseType Type of database. Supported databases are db2, oracle, informix, derby, sqlserver, db2zos, and db2iseries.
dbURL Database URL for direct access mode. For example: jdbc:db2:wim.
dbDriver Name of the database driver. For example: com.ibm.db2.jcc.DB2Driver.
dbAdminId Database administrator ID for direct access mode. For example: db2admin. For a Apache Derby v10.2 embedded database, dbAdminId is not required.
dbAdminPassword Password associated with the dbAdminId. For a Apache Derby v10.2 embedded database, dbAdminPassword is not required.
dn Default organization uniqueName to replace. For example: o=yourco. If it is not set, o=Default Organization is used.
wasAdminId WAS admin user ID. The ID should be a short name, not a uniqueName. For example: wasadmin. After creation, the uniqueName is uid=wasadmin, <defaultOrg>
wasAdminPassword WAS admin user password. If wasAdminId is set, then this parameter is mandatory.
saltLength (Integer) Salt length of the randomly generated salt for password hashing.
encryptionKey Password encryption key. Set the password encryption key to match the encryption key in the wimconfig.xml file for the repository. If the encryption key is not set, the default is used.
derbySystemHome Home location of the Apache Derby v10.2 system if you are setting up a Apache Derby v10.2 database.
reportSqlError Whether to report SQL errors while setting up databases.
file Full path to a file containing the input parameters. Each input parameter must match a corresponding parameter as it would be typed on the command line, and it must be placed in a key=value pair. Each pair must be on a separate line.
dbSchema Database schema where to create the federated repository tables. The schema should exist in the database. The default value is the default schema of the database according to the database type. Typically, the default schema is the namespace of the current database user.

deleteIdMgrDBTables.sh
Delete tables in the database.

schemaLocation Location of WAS_HOME/etc/wim/setup
databaseType Type of database. Supported databases are db2, oracle, informix, derby, sqlserver, db2zos, and db2iseries.
dbURL Database URL for direct access mode. For example: jdbc:db2:wim.
dbDriver Name of the database driver. For example: com.ibm.db2.jcc.DB2Driver.
dbAdminId Database administrator ID for direct access mode. For example: db2admin. For a Apache Derby v10.2 embedded database, dbAdminId is not required.
dbAdminPassword Password associated with the dbAdminId. For a Apache Derby v10.2 embedded database, dbAdminPassword is not required.
derbySystemHome Home location of the Apache Derby v10.2 system if you are setting up a Apache Derby v10.2 database.
reportSqlError Whether to report SQL errors while setting up databases.
file Full path to a file containing the input parameters. Each input parameter must match a corresponding parameter as it would be typed on the command line, and it must be placed in a key=value pair. Each pair must be on a separate line.
dbSchema Database schema from which to delete the federated repository tables. The schema should exist in the database. The default value is the default schema of the database according to the database type. Typically, the default schema is the namespace of the current database user.

setupIdMgrPropertyExtensionRepositoryTables.sh
Set up property extension repository. The default behavior includes creating and populating the tables in the database.

schemaLocation Location of WAS_HOME/etc/wim/setup
laPropXML Location of the property extension repository definition XML file.
databaseType Type of database. Supported databases are db2, oracle, informix, derby, sqlserver, db2zos, and db2iseries.
dbURL Database URL for direct access mode. For example: jdbc:db2:wim.
dbAdminId Database administrator ID for direct access mode. For example: db2admin. For a Apache Derby v10.2 embedded database, dbAdminId is not required.
dbAdminPassword Password associated with the dbAdminId. For a Apache Derby v10.2 embedded database, dbAdminPassword is not required.
derbySystemHome Home location of the Apache Derby v10.2 system if you are setting up a Apache Derby v10.2 database.
reportSqlError Whether to report SQL errors while setting up databases.
skipDBCreation Whether to create the tables in the property extension repository.
If set to false or not specified, tables are created and populated.
If set to true, manually set up the property extension repository before running this command so that the tables get populated.
file Full path to file containing the input parameters. Each input parameter must match a corresponding parameter as it would be typed on the command line, and it must be placed in a key=value pair. Each pair must be on a separate line.
dbSchema The database schema where to create the federated repository tables. The schema should exist in the database. The default value is the default schema of the database according to the database type. Typically, the default schema is the namespace of the current database user.

deleteIdMgrPropertyExtensionRepositoryTables.sh
Delete the tables in the property extension database.

schemaLocation Location of WAS_HOME/etc/wim/setup
databaseType Type of database. Supported databases are db2, oracle, informix, derby, sqlserver, db2zos, and db2iseries.
dbURL Database URL for direct access mode. For example: jdbc:db2:wim.
dbDriver Name of the database driver. For example: com.ibm.db2.jcc.DB2Driver.
dbAdminId Database administrator ID for direct access mode. For example: db2admin. For a Apache Derby v10.2 embedded database, dbAdminId is not required.
dbAdminPassword Password associated with the dbAdminId. For a Apache Derby v10.2 embedded database, dbAdminPassword is not required.
derbySystemHome Home location of the Apache Derby v10.2 system if you are setting up a Apache Derby v10.2 database.
reportSqlError Whether to report SQL errors while setting up databases.
file Full path to a file containing the input parameters. Each input parameter must match a corresponding parameter as it would be typed on the command line, and it must be placed in a key=value pair. Each pair must be on a separate line.
dbSchema Database schema from which to delete the federated repository tables. The schema should exist in the database. The default value is the default schema of the database according to the database type. Typically, the default schema is the namespace of the current database user.

setupIdMgrEntryMappingRepositoryTables.sh
Set up the entry mapping repository, which includes creating and populating the tables of the repository.

schemaLocation Location of WAS_HOME/etc/wim/setup
databaseType Type of database. Supported databases are db2, oracle, informix, derby, sqlserver, db2zos, and db2iseries.
dbURL Database URL for direct access mode. For example: jdbc:db2:wim.
dbDriver Name of the database driver. For example: com.ibm.db2.jcc.DB2Driver.
dbAdminId Database administrator ID for direct access mode. For example: db2admin. For a Apache Derby v10.2 embedded database, dbAdminId is not required.
dbAdminPassword Password associated with the dbAdminId. For a Apache Derby v10.2 embedded database, dbAdminPassword is not required.
derbySystemHome Home location of the Apache Derby v10.2 system if you are setting up a Apache Derby v10.2 database.
reportSqlError Whether to report SQL errors while setting up databases.
file Full path to a file containing the input parameters. Each input parameter must match a corresponding parameter as it would be typed on the command line, and it must be placed in a key=value pair. Each pair must be on a separate line.
dbSchema Database schema where to create the federated repository tables. The schema should exist in the database. The default value is the default schema of the database according to the database type. Typically, the default schema is the namespace of the current database user.

deleteIdMgrEntryMappingRepositoryTables
Delete the tables in the entry mapping repository.

schemaLocation Location of WAS_HOME/etc/wim/setup
databaseType Type of database. Supported databases are db2, oracle, informix, derby, sqlserver, db2zos, and db2iseries.
dbURL Database URL for direct access mode. For example: jdbc:db2:wim.
dbDriver Name of the database driver. For example: com.ibm.db2.jcc.DB2Driver.
dbAdminId Database administrator ID for direct access mode. For example: db2admin. For a Apache Derby v10.2 embedded database, dbAdminId is not required.
dbAdminPassword Password associated with the dbAdminId. For a Apache Derby v10.2 embedded database, dbAdminPassword is not required.
derbySystemHome Home location of the Apache Derby v10.2 system if you are setting up a Apache Derby v10.2 database.
reportSqlError Whether to report SQL errors while setting up databases.
file Full path to a file containing the input parameters. Each input parameter must match a corresponding parameter as it would be typed on the command line, and it must be placed in a key=value pair. Each pair must be on a separate line.
dbSchema Database schema from which to delete the federated repository tables. The schema should exist in the database. The default value is the default schema of the database according to the database type. Typically, the default schema is the namespace of the current database user.

Sample command line usage:
Set up a database...

cd WAS_HOME/bin
./wsadmin.sh
$AdminTask setupIdMgrDBTables {-schemaLocation "C:/WAS/etc/wim/setup" -dbPropXML "C:/WAS/etc/wim/setup/wimdbproperties.xml" -databaseType db2 -dbURL jdbc:db2:wim -dbAdminId db2admin -dbDriver com.ibm.db2.jcc.DB2Driver -dbAdminPassword db2adminPwd -reportSqlError true}

Delete database tables...

$AdminTask deleteIdMgrDBTables {-schemaLocation "C:/WAS/etc/wim/setup" -databaseType db2 -dbURL jdbc:db2:wim -dbAdminId db2admin -dbDriver com.ibm.db2.jcc.DB2Driver -dbAdminPassword db2adminPwd -reportSqlError true}

Set up a property extension repository...

$AdminTask setupIdMgrPropertyExtensionRepositoryTables {-schemaLocation "C:/WAS/etc/wim/setup" -laPropXML "C:/WAS/etc/wim/setup/wimlaproperties.xml" -databaseType db2 -dbURL jdbc:db2:wim -dbAdminId db2admin -dbDriver com.ibm.db2.jcc.DB2Driver -dbAdminPassword db2adminPwd -reportSqlError true}

Delete a property extension repository...
$AdminTask deleteIdMgrPropertyExtensionRepositoryTables {-schemaLocation "C:/WAS/etc/wim/setup " -databaseType db2 -dbURL jdbc:db2:wim -dbAdminId db2admin -dbDriver com.ibm.db2.jcc.DB2Driver -dbAdminPassword db2adminPwd -reportSqlError true}

Set up an entry mapping repository...

$AdminTask setupIdMgrEntryMappingRepositoryTables {-schemaLocation "C:/WAS/etc/wim/setup" -databaseType db2 -dbURL jdbc:db2:wim -dbAdminId db2admin -dbDriver com.ibm.db2.jcc.DB2Driver -dbAdminPassword db2adminPwd -reportSqlError true}

Delete an entry mapping repository...
$AdminTask deleteIdMgrEntryMappingRepositoryTables {-schemaLocation "C:/WAS/etc/wim/setup" -databaseType db2 -dbURL jdbc:db2:wim -dbAdminId db2admin -dbDriver com.ibm.db2.jcc.DB2Driver -dbAdminPassword db2adminPwd -reportSqlError true}

Sample CLI Usage using -file option:
To set up a database with the -file option using the example params.txt file below...

$AdminTask setupIdMgrDBTables {–file C:/params.txt -dbPropXML "C:/OverrideDBPropParam/wimdbproperties.xml"}
Params.txt

schemaLocation=C:/WAS/etc/wim/setup
dbPropXML=C:/IBM/WebSphere/AppServer/profiles/default/config/cells/mycell/wim/config/wimdbproperties.xml
laPropXML=C:/IBM/WebSphere/AppServer/profiles/default/config/cells/mycell/wim/config/wimlaproperties.xml
databaseType=db2
dbURL=jdbc:db2:wim
dbDriver=com.ibm.db2.jcc.DB2Driver
reportSqlError=true
dn=o=db.com
dbAdminId=db2admin
dbAdminPassword=dbPassword
wasAdminId=wasadmin
wasAdminPassword=wasadmin1

Set up a database with the -file option using a file only...

$AdminTask setupIdMgrDBTables {-file C:/params.txt}

The use of a file only works if -file is the only parameter specified on the command line. If other parameters are specified then the file is completely ignored, and only the parameters on the command line are used to execute the command.

Related
Manually set up the property extension repository for federated repositories
Manually set up the property extension repository for DB2 for iSeries or DB2 for z/OS
Configure the WAS data source
Configure an entry mapping repository in a federated repository
Configure a property extension repository in a federated repository
Entry mapping repository settings
Property extension repository settings

+
Search Tips | Advanced Search

schemaLocation	Location of WAS_HOME/etc/wim/setup
dbPropXML	Location of database repository property definition XML file.
databaseType	Type of database. Supported databases are db2, oracle, informix, derby, sqlserver, db2zos, and db2iseries.
dbURL	Database URL for direct access mode. For example: jdbc:db2:wim.
dbDriver	Name of the database driver. For example: com.ibm.db2.jcc.DB2Driver.
dbAdminId	Database administrator ID for direct access mode. For example: db2admin. For a Apache Derby v10.2 embedded database, dbAdminId is not required.
dbAdminPassword	Password associated with the dbAdminId. For a Apache Derby v10.2 embedded database, dbAdminPassword is not required.
dn	Default organization uniqueName to replace. For example: o=yourco. If it is not set, o=Default Organization is used.
wasAdminId	WAS admin user ID. The ID should be a short name, not a uniqueName. For example: wasadmin. After creation, the uniqueName is uid=wasadmin, <defaultOrg>
wasAdminPassword	WAS admin user password. If wasAdminId is set, then this parameter is mandatory.
saltLength (Integer)	Salt length of the randomly generated salt for password hashing.
encryptionKey	Password encryption key. Set the password encryption key to match the encryption key in the wimconfig.xml file for the repository. If the encryption key is not set, the default is used.
derbySystemHome	Home location of the Apache Derby v10.2 system if you are setting up a Apache Derby v10.2 database.
reportSqlError	Whether to report SQL errors while setting up databases.
file	Full path to a file containing the input parameters. Each input parameter must match a corresponding parameter as it would be typed on the command line, and it must be placed in a key=value pair. Each pair must be on a separate line.
dbSchema	Database schema where to create the federated repository tables. The schema should exist in the database. The default value is the default schema of the database according to the database type. Typically, the default schema is the namespace of the current database user.

schemaLocation	Location of WAS_HOME/etc/wim/setup
laPropXML	Location of the property extension repository definition XML file.
databaseType	Type of database. Supported databases are db2, oracle, informix, derby, sqlserver, db2zos, and db2iseries.
dbURL	Database URL for direct access mode. For example: jdbc:db2:wim.
dbAdminId	Database administrator ID for direct access mode. For example: db2admin. For a Apache Derby v10.2 embedded database, dbAdminId is not required.
dbAdminPassword	Password associated with the dbAdminId. For a Apache Derby v10.2 embedded database, dbAdminPassword is not required.
derbySystemHome	Home location of the Apache Derby v10.2 system if you are setting up a Apache Derby v10.2 database.
reportSqlError	Whether to report SQL errors while setting up databases.
skipDBCreation	Whether to create the tables in the property extension repository. If set to false or not specified, tables are created and populated. If set to true, manually set up the property extension repository before running this command so that the tables get populated.
file	Full path to file containing the input parameters. Each input parameter must match a corresponding parameter as it would be typed on the command line, and it must be placed in a key=value pair. Each pair must be on a separate line.
dbSchema	The database schema where to create the federated repository tables. The schema should exist in the database. The default value is the default schema of the database according to the database type. Typically, the default schema is the namespace of the current database user.