rwroe
Member
Hi There, We are currently experiencing an issue on the iseries where a number of E1 tables are not journalling automatically and as a result we are hitting a number of performance issues. We have tried to get a complete list of the tables that should be journalled but Oracle dont appear to have this full list. We are on ERP 9.00 Tools release 8.98 and following versions on iseries SF99636 DB2 WEB QUERY FOR IBM I V1.1.2 4
SF99626 6.1 ELECTRONIC SERVICES GROUP PTF 7
SF99616 DB2 WEB QUERY FOR IBM I V1.1.1 11
SF99610 CUMULATIVE PTF PACKAGE C1256610 11256 (year 2011, day 256) <<<<<< last cum level
SF99609 GROUP HIPER 109
SF99608 GROUP SECURITY 24
SF99601 DB2 FOR IBM I 23
SF99562 JAVA 18
SF99356 PRINT GROUP PTF FOR V6R1M0 21
SF99354 TCP/IP GROUP PTF 13
SF99353 WEBSPHERE APP SERVER V6.1 17 <<< service pack 6.1.0.29 applied
SF99187 BACKUP RECOVERY SOLUTIONS 24
SF99144 PERFORMANCE TOOLS 4
SF99115 IBM HTTP SERVER FOR I 23
Does anyone know how we can make sure all the E1 tables are journalled. Thanks Rose
SF99626 6.1 ELECTRONIC SERVICES GROUP PTF 7
SF99616 DB2 WEB QUERY FOR IBM I V1.1.1 11
SF99610 CUMULATIVE PTF PACKAGE C1256610 11256 (year 2011, day 256) <<<<<< last cum level
SF99609 GROUP HIPER 109
SF99608 GROUP SECURITY 24
SF99601 DB2 FOR IBM I 23
SF99562 JAVA 18
SF99356 PRINT GROUP PTF FOR V6R1M0 21
SF99354 TCP/IP GROUP PTF 13
SF99353 WEBSPHERE APP SERVER V6.1 17 <<< service pack 6.1.0.29 applied
SF99187 BACKUP RECOVERY SOLUTIONS 24
SF99144 PERFORMANCE TOOLS 4
SF99115 IBM HTTP SERVER FOR I 23
Does anyone know how we can make sure all the E1 tables are journalled. Thanks Rose
