ca.portal.admin

Changing a sorted chained set to a user owned sorted index set

Discussion created by ca.portal.admin on Feb 1, 2006
Hello All:



Has anyone ever used unload and reload to change a sorted chained set to
a

sorted user owned index set?



If so, can you describe your process?



Bill Allen



"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Visual DBA
"Hi,



Does Visual DBA collect task statistics that can be saved, and viewed
later, or is it just a real-time monitor to capture current happenings?



I know that it can be used to modify settings etc online.



Thanks



Chris Wood

Alberta Department of Energy

CANADA

This communication is intended for the use of the recipient to which it is addressed, and may contain confidential, personal and or privileged information. Please contact us immediately if you are not the intended recipients of this communication, and do not copy, distribute, or take action relying on it. Any communication received in error, or subsequent reply, should be deleted or destroyed.

"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: #VIBDS Change for release 16.0
"Hi Bill and Peter,

From what I recall in teaching IDMS-DB Internals up through 14.1 many years
ago (including at BT so many people there have the internals material I
believe); In the area of transaction management for IDMS SQL architecture
introduced in 12.0, the TBX / TBK structure was introduced to manage
multiple run units (transactions) per task that exist when executing an IDMS
SQL program. So in these multiple run unit scenarios, one will have more
than one VB50 chained off each TCE and each VB50 will point to a TBX-TBK set
for the ""Transaction"" SQL info.

Bottom line; if you write an exit that will also support SQL, one should
check for multiple VB50s chained off the TCE and then follow the chains thru
the TBK which should get you addressibility to the TBKLID .

Sorry Bill for the mini-lecture as hopefully someone will get you an exit
example.

If you aren't able to get a contributed exit, let me know and I will help
put one together for you.

Regards,
Joe Perkins

Outcomes