tag:blogger.com,1999:blog-4516533711330247058.post6273901602788071541..comments2024-03-28T00:10:23.672-07:00Comments on Robert's Db2 blog: A DB2 11 for z/OS Temporal Data Enhancement You Might Have MissedRoberthttp://www.blogger.com/profile/02058625981006623480noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-4516533711330247058.post-57670099478374721182021-12-21T15:45:51.657-08:002021-12-21T15:45:51.657-08:00In the SYSIBM.SYSTABLES catalog table, the value i...In the SYSIBM.SYSTABLES catalog table, the value in the CLUSTERRID column is 1 for a table if "The table is a system-period temporal table with versioning, and the table is defined with the ON DELETE ADD EXTRA ROW clause;' otherwise the value for a table in this column is 0 (see https://www.ibm.com/docs/en/db2-for-zos/12?topic=tables-systables).<br /><br />Robert Roberthttps://www.blogger.com/profile/02058625981006623480noreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-88848709213995950342021-12-21T02:59:04.273-08:002021-12-21T02:59:04.273-08:00Where in the Db2 catalog is the information stored...Where in the Db2 catalog is the information stored for "ON DELETE ADD EXTRA ROW"<br /><br />Hans-Henrik Gudmann/Tommerup Denmarkhh.gudmannhttps://www.blogger.com/profile/06396925461439250296noreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-84916885606334190992015-06-19T10:05:12.479-07:002015-06-19T10:05:12.479-07:00P.S. no worries, you're on a road trip, you we...P.S. no worries, you're on a road trip, you were in my home town Toronto on 1 June I believe. Sorry I missed you.<br /><br />Michael Harper/TD BankAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-76181672751411602172015-06-19T09:49:34.782-07:002015-06-19T09:49:34.782-07:00This seems to be specific to RACF and we are not a...This seems to be specific to RACF and we are not a RACF shop.<br /><br />Michael Harper/TD BankAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-59807820426186580822015-06-18T17:22:51.672-07:002015-06-18T17:22:51.672-07:00Sorry about the long-delayed response, Michael.
E...Sorry about the long-delayed response, Michael.<br /><br />Even when a network-attached application connects to DB2 for z/OS with an auth ID that is tied to the application, versus being tied to a user, you should be able to get an individual RACF ID to be associated with an individual user of the application (and have that individual RACF ID be that user's current SQL ID) by way of enterprise identity mapping, which effectively became available with DB2 10 for z/OS (it was do-able with DB2 9, but became much easier to implement with DB2 10). I blogged about enterprise identity mapping in a DB2 context a couple of years ago. That blog entry is at http://robertsdb2blog.blogspot.ca/2013/06/db2-10-for-zos-and-enterprise-identity.html.<br /><br />Robert Roberthttps://www.blogger.com/profile/02058625981006623480noreply@blogger.comtag:blogger.com,1999:blog-4516533711330247058.post-5229842326649683552015-06-09T04:38:13.917-07:002015-06-09T04:38:13.917-07:00I am not convinced that GENERATED ALWAYS AS (CURRE...I am not convinced that GENERATED ALWAYS AS (CURRENT SQLID) is useful. Many of our operations use Websphere Data Sources which connect to DB2 z/OS with a generic application SQLID (we use the phrase "proxy ID"). A possible better approach could be a user modifiable special register that defaults to CURRENT SQLID which would allow the application code to set the register value to something appropriate such as a value from one of the workstation registers.<br /><br />Michael Harper/TD BankAnonymousnoreply@blogger.com