 |
Software > WebSphere > WebSphere Portal Family >
|
|
|
|
Workspace Validation utility to verify JCR Workspace database views are in sync for DB2 on z/OS
|
| | | Abstract | The following document explains how to use DB2 on z/OS backup procedures in conjunction with WebSphere Portal. If you are using DB2 on z/OS and WebSphere Portal and you want to backup only the data in the tables without any actual schema information you will find issues after the restore of the tables as this procedure conflicts with the WCM/JCR runtime strategy whereby Portal
creates Database Views for every dynamic workspace (DWS).
The Database Views don't get backed up as part of this simple backup. Thus if a restore were to occur, we will likely have Database views created in the DB that don't yet exist as allocated Dynamic Workspaces yet. In such a restored system, eventually the creation of new content will cause JCR to create an "existing" Database view which will cause an error.
The document explains how to solve this issue and so allow the DB2 on z/OS backup procedure to be used with WebSphere Portal. | | | | | | | | Content |
Usage instructions:
To remedy the problem explained above after a restore, JCR is providing a Workspace Validation utility which will verify that the JCR Workspace database views are in sync with the allocated workspaces. The Workspace Validation utility is designed to run when WebSphere Portal is started. The action of the utility is controlled by a setting in the icm.properties file with the following settings:
# Workspace Validation Support
# Controls workspace validation option for JCR startup. This option determines whether or not JCR will validate
# the existence of the proper number of database views used by JCR Workspaces. There are three option. SKIP is
# the default if no value is specified.
# SKIP - Peform no validation
# REPORT - Log to the SystemOut log any necessary corrections
# FIX - Make and Log to the SystemOut log the necessary corrections
#jcr.workspace.view.validation=REPORT
The utility to remove unused views is also available via APAR PK69082 on the 6.0.1.3 and 6.0.1.4 fix pack level.
On previous levels it is also possible to delete the database views via the following SQL:
By running the SQL below the names of the views (SYSVIEWNAME column) are returned and can then be deleted.
PLEASE NOTE that all instances of JCRU0000 will need to be replaced with the appropriate schema name for the customer.
SELECT JCRVIEWNAME, WSFLAG, WSTYPE, SYSVIEWNAME
FROM
(
SELECT 'ICMSTJCRL'||RIGHT(RTRIM('0000'||CAST(WSID AS CHAR(11))),5) AS JCRVIEWNAME, WSFLAG, WSTYPE
FROM JCRU0000.ICMSTJCRWS
UNION ALL
SELECT 'ICMSTJCRLV'||RIGHT(RTRIM('0000'||CAST(WSID AS CHAR(11))),5) AS JCRVIEWNAME, WSFLAG, WSTYPE
FROM JCRU0000.ICMSTJCRWS
UNION ALL
SELECT 'ICMSTJCRLR'||RIGHT(RTRIM('0000'||CAST(WSID AS CHAR(11))),5) AS JCRVIEWNAME, WSFLAG, WSTYPE
FROM JCRU0000.ICMSTJCRWS
UNION ALL
SELECT 'ICMSTJCRN'||RIGHT(RTRIM('0000'||CAST(WSID AS CHAR(11))),5) AS JCRVIEWNAME, WSFLAG, WSTYPE
FROM JCRU0000.ICMSTJCRWS
) JCRVIEWLIST
FULL OUTER JOIN
(
SELECT RTRIM(NAME) AS SYSVIEWNAME FROM SYSIBM.SYSVIEWS WHERE CREATOR='JCRU0000'
AND ( NAME LIKE 'ICMSTJCRL%' OR NAME LIKE 'ICMSTJCRN%')
) AS SYSVIEWLIST
ON JCRVIEWNAME = SYSVIEWNAME
WHERE
(WSFLAG IS NOT NULL OR (WSFLAG IS NULL AND JCRVIEWNAME IS NULL ))
AND
( (JCRVIEWNAME IS NULL AND SYSVIEWNAME IS NOT NULL ) OR (JCRVIEWNAME IS NOT NULL AND SYSVIEWNAME IS NULL ) ) ;
| | | | | | | |
|
|
| IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml. |
|
|
|
|
| Please take a moment to complete this form to help us better serve you. |
|
 |
|
|
|
|
|
|
| Product categories: |
|
| | Software | |
| | Organizational Productivity, Portals & Collaboration | |
| | Portals | |
| | WebSphere Portal | |
|
| Operating system(s): |
| |
AIX, HP-UX, Linux, Solaris, Windows, z/OS
|
|
| Software version: |
| |
6.0.1.5
|
|
| Software edition: |
| |
Enable, Extend, Server
|
|
| Reference #: |
| |
7014153
|
|
| IBM Group: |
| | Software Group |
|
| Modified date: |
| | 2009-10-27 |
|
|
