Hello Venkata,
A change to a table that could change the optimization of a plan will cause the plan to be marked invalid. When you alter a table, let's say add a key, plans that access that table may benefit from that new key. Those plans are marked invalid. The next time that plan is called, it is rebuilt and will take advantage of that new key, if appropriate. I see a message pair like the following, in PXX, when an invalid plan is next accessed:
S00E6 STMTEXEC: SYSUSR GRXQ0136 N.GRXQ0136 N NOT EXECUTABLE - REBINDING
S00E6 STMTEXEC: SYSUSR GRXQ0136 Y .GRXQ0136 Y REBIND SUCCESSFUL
In database 2, DATA-DICT, there is a PLAN table with a field PLN_VALID that will contain an 'N' between the time of the alter and the rebind. Before the alter and after the successful rebind, the field will be 'Y'.
As far as "remote connections are not possible in Datacom", I'm not certain what you mean. Are you asking if your databases are secure from access outside your organization? A database's purpose is to serve data. Like any database platform, Datacom should be secured to prevent access that you don't want to allow.
Original Message:
Sent: 06-17-2021 03:45 PM
From: Mallina venkata Rajesh
Subject: Doubt in CA datacom
Hi All,
We are supporting datacom, without any prior knowledge or training. I had following questions
1. I hope in datacom plan level binds are performed. How to check dependent plans on datacom table. We are performing alters, but not looking plans.
2. I hope datacom can not be access from remote.
Please clarify my doubts
Thanks and Regards
Venkata rama rajesh #