transfer_db2_zos.properties
############################################################################## # # WebSphere Portal 5.1 configuration file for database transfer: # From: Cloudscape # To: DB2-zOS # # NOTE: Do NOT enclose any value in quotes! # NOTE: Windows paths must use '/', not '\'. # NOTE: Windows long paths are OK. # NOTE: Properties are immutable. Once set, they cannot be overriden. # ############################################################################### ############################################################################### # # How to use this file: # # 1. Consult the Information Center for detailed instructions on the properties and tasks # listed in this file: # Configuring> Database(Windows/UNIX)> Configuring Databases> DB2 for z/OS # 2. Change into the <wp_root>/config directory # 3. Edit this file to match your environment # 4. Import the contents of this file into wpconfig.properties: # on Windows: # WPSconfig -DparentProperties="<full_path_to_this_file>" -DSaveParentProperties=true # # on other platforms # ./WPSconfig.sh -DparentProperties=<full_path_to_this_file> -DSaveParentProperties=true # 5. Test connections to databases: # on Windows: # WPSconfig validate-database-connection-wps # WPSconfig validate-database-connection-wmm # # If you have configured CM and Personalization (configured by default), also test those connections: # WPSconfig validate-database-connection-jcr # WPSconfig validate-database-connection-feedback # WPSconfig validate-database-connection-likeminds # # on other platforms # ./WPSconfig.sh validate-database-connection-wps # ./WPSconfig.sh validate-database-connection-wmm # # If you have configured CM and Personalization (configured by default), also test those connections: # ./WPSconfig.sh validate-database-connection-jcr # ./WPSconfig.sh validate-database-connection-feedback # ./WPSconfig.sh validate-database-connection-likeminds # # 6. Import data to the target databases: # on Windows: # WPSconfig database-transfer # # on other platforms # ./WPSconfig.sh database-transfer ############################################################################### ############################################################################### # Database Properties - BEGIN ############################################################################### # DbSafeMode: This only applies to Database specific tasks. If it is set to true # the databases will not be created, initialized, or removed. # { false | true } DbSafeMode=false # DbType: The type of database to be used for WebSphere Portal DbType=db2_zos # DbDriver: The name of class SqlProcessor will use to import SQL files, also known as "JDBC provider" DbDriver=COM.ibm.db2.jdbc.app.DB2Driver # DbDriverDs: The name of class SqlProcessor will use to import SQL files via data source DbDriverDs=COM.ibm.db2.jdbc.DB2XADataSource #DbLibrary: The directory and name of the zip file containing db.driver class DbLibrary=<SQLLIB>/java12/db2java.zip ############################################################################### # WPS Database Properties - BEGIN ############################################################################### # WpsDbName: The name of the WebSphere Portal database # Note: This value should also appear as the database element in DbUrl WpsDbName=wps # WpsDbNameOnZos: name of database on zos WpsDbNameOnZos=wpsdb # DbUrl: The WPS database URL # Note: The database element of this value should match the value of WpsDbName DbUrl=jdbc:db2:wpsdb # DbUser: The WPS database administrator user ID DbUser=<wps_user_name> # DbPassword: The WPS database administrator password DbPassword= # **Required for Non-Windows only** # WpsXDbName: The TCPIP Alias for the database to be used as ds name WpsXDbName=wps5TCP # WpsDbNode: This value is the node for the WebSphere Portal database WpsDbNode=wpsNode ################################################################## # WPS Database Properties - END ################################################################## ################################################################## # WMM Database Properties - BEGIN ################################################################## # WmmDbName: The name of the WebSphere Member Manager # Note: This value should also appear as the database element in WmmDbUrl WmmDbName=wpsdb # WmmDbNameOnZos: name of db on zos WmmDbNameOnZos=wpsdb # WmmDbUrl: The database URL # Note: The database element of this value should match the value of WmmDbName WmmDbUrl=jdbc:db2:wpsdb # WmmDbUser: The database administrator user ID WmmDbUser=<wmm_db_user_name> # WmmDbPassword: The database administrator password WmmDbPassword= ################################################################## # WMM Database Properties - END ################################################################## ################################################################## # JCR Database Properties - BEGIN ################################################################## # JcrDbName: The name of the WebSphere Portal database for JCR tables # Note: This value should also appear as the database element in JcrDbUrl JcrDbName=jcrdb # JcrDbUser: The JCR database administrator User ID/schema name JcrDbUser=<jcr_db_user> # JcrDbPassword: The JCR database administrator password JcrDbPassword=ReplaceWithYourDbAdminPwd # JcrDsName: The name of datasource to be used for JCR JcrDsName=JCRDS # JcrDbUrl: The JCR database URL # Note: The database element of this value should match the value of JcrDbName JcrDbUrl=jdbc:db2:jcrdb # Debug level for JCR database utilities JcrDebugLevel=2 # JcrDbUnicode: Indicates whether or not the JCR database is unicode. # Y: is unicode # N: is NOT unicode JcrDbUnicode=N ################################################################## # JCR Database Properties - END ################################################################## ################################################################## # Personalization Database Properties - BEGIN ################################################################## # **Required for Non-Windows platforms when using DB2 only** # PznDbNode: This value is the node for the Feedback and Likeminds database PznDbNode=pznNode # **Required for Non-Windows platforms when using DB2 only** # FeedbackXDbName: The TCPIP Alias for the database FeedbackXDbName=fdbk5TCP # FeedbackDbName: The name of the feedback database. # Note: This value should also appear as the database element in FeedbackDbUrl FeedbackDbName=fdbkdb # FeedbackDbNameOnZos: The name of the remote Pzn Feedback database FeedbackDbNameOnZos=fdbk5zos # **Required for DB2 for z/OS and OS/390 only** # FeedbackDbTablespace: The name of the feedback database tablespace. FeedbackDbTablespace=fdbkdbts # **Required for DB2, DB2 for z/OS and OS/390** # # **For SQL Server and Oracle only, this value MUST be set to FEEDBACK** # **which corresponds to the user FEEDBACK in your SQL Server or Oracle database** # FeedbackDbUser: The database user for feedback database. FeedbackDbUser=<feedback_db_user> # FeedbackDbPassword: The database password for feedback database. FeedbackDbPassword= # FeedbackDbUrl: The Feedback database URL # Note: The database element of this value should match the value of FeedbackDbName FeedbackDbUrl=jdbc:db2:fdbkdb # **Required for Non-Windows platforms when using DB2 only** # LikemindsXDbName: The TCPIP Alias for the database LikemindsXDbName=lmdb5TCP # LikemindsDbName: The name of the Likeminds database. # Note: This value should also appear as the database element in LikemindsDbUrl LikemindsDbName=lmdb51 # **Required for DB2 for z/OS and OS/390 only** # LikemindsDbNameOnZos: The name of the remote Feedback Likeminds database LikemindsDbNameOnZos=lmdb5zos # **Required for DB2 for z/OS and OS/390 only** # LikemindsDbTablespace: The name of the Likeminds database tablespace. LikemindsDbTablespace=lmdb51ts # **Required for DB2, DB2 for z/OS and OS/390** # LikemindsDbUser: The database user for Likeminds database. LikemindsDbUser=<likeminds_db_user> # LikemindsDbPassword: The database password for Likeminds database. LikemindsDbPassword= # LikemindsDbUrl: The Likeminds database URL # Note: The database element of this value should match the value of LikemindsDbName LikemindsDbUrl=jdbc:db2:lmdb51 ################################################################## # Personalization Database Properties - END ##################################################################WebSphere is a trademark of the IBM Corporation in the United States, other countries, or both.
IBM is a trademark of the IBM Corporation in the United States, other countries, or both.