|
|
|
CA IDMS Visual DBA manipulates a large number of CA IDMS objects that are managed on the mainframe using the following:
The following list shows the objects that can be explored using CA IDMS Visual DBA.
Object Id and Name
1 Dictionary
2 SQL Schema
3 Table in Schema
4 Index
5 View on Table
6 Constraint Table referenced
7 Constraint Table referencing
8 Access Module for Table
9 Calc Key
10 Column
11 Check Condition
12 Grantee on Table
13-24 Grantees
25 View in Schema
26 View Component
27 Access Module for View
28 Column of View
29 View Definition
30 Grantee on View
31-41 Grantees
42 Table Procedure in Schema
43 Key in Table Procedure
44 Parameter of Table Procedure
45 Access Module for Table Procedure
46 Grantee on Table Procedure
47-57 Grantees
58 Procedure in Schema
59 Key in Procedure
60 Parameter of Procedure
61 Routine Body of Procedure
62 Access Module for Procedure
63 Grantee on Procedure
64-74 Grantees
75 Function in Schema
76 Parameter of Function
77 Routine Body of Function
78 Access Module for Function
79 Grantee on Function
80-90 Grantees
91 Non SQL Table in Schema
92 Column of non SQL Table
93 Access Module using non SQL Table
94 Grantee on non SQL Table
95-100 Grantees
101 Constraint
102 Referencing Table in Constraint
103 Referenced Table in Constraint
104 Access Module
105 Relational Command Module in AM
106 Schema Mapping of AM
107 Area with Ready Mode in AM
108 Table accessed
109 View accessed
110 Table Procedure accessed
111 Procedure accessed
112 Function accessed
113 Non SQL Table accessed
114 Grantee on Access Module
115-120 Grantees
121 Grantee for Schema
122-127 Grantees
128 Table Like
129 Table
130 View
131 Table Procedure
132 Procedure
133 Function
134 Non SQL Table
135 Relational Command Module
136 Non SQL Schema
137 Area in Non SQL Schema
138 Area Procedure
139 Record in Area
140 Record
141 Record Procedure
142 Data Compression Table
143 Record Synonym
144 Record Element
145 Element Synonym
146 Element Description
147 Comment
148 Definition
149 Index Key
150 Olq Header
151 Culprit Header
152 Occurs Depending On
153 Element Value
154 Value
155 External Picture
156 Edit Table Value
157 Code Table Value
158 Element Indexed By
159 Cobol Indexed By
160 Set owned by Record
161 Set Record is member
162 Structure Shared By
163 Set
164 Owner Record of Set
165 Member Record of Set
166 Record Procedure
167 Data Compression Table
168 Record Synonym
169 Record Element
170 Set owned by Record
171 Set Record is member
172 Record Control Key
173 Record Foreign Key
174 Subschema
175 Area in Subschema
176 Record in Subschema
177 Element of Subschema Record
178 Set in Subschema
179 Load Module
180 Program using Subschema
181 Area used in Program
182 Area Statistics for Program
183 Record in Area
184 Record used in Program
185 Record Statistics for Program
186 Element of Subschema Record
187 Set used in Program
188 Set Statistics for Program
189 Owner Record of Set
190 Member Record of Set
191 Class/Attribute
192 Comment
193 Registree for Subschema
194 Registree for All
195 Registree for .Update
196 Registree for ..Delete
197 Registree for ..Modify
198 Registree for ...Display
199 Registree for Public Access
200 Responsible for Subschema
201 Responsible for Creation
202 Responsible for Deletion
203 Responsible for Update
204 Responsible for None
205 Class/Attribute
206 Comment
207 Grantee for Use
208 Registree for Schema
209 Registree for All
210 Registree for .Update
211 Registree for ..Delete
212 Registree for ..Modify
213 Registree for ...Display
214 Registree for Public Access
215 Responsible for Schema
216 Responsible for Creation
217 Responsible for Deletion
218 Responsible for Update
219 Responsible for None
220 IDD Class & Record & Module
221 Class
222 Attribute
223 IDD Record
224 IDD Record Synonym
225 IDD Record Element
226 IDD Element Synonym
227 IDD Element Description
228 IDD Comment
229 IDD Definition
230 IDD Index Key
231 IDD Olq Header
232 IDD Culprit Header
233 IDD Occurs Depending On
234 IDD Element Value
235 IDD Value
236 IDD External Picture
237 IDD Edit Table Value
238 IDD Code Table Value
239 IDD Element Indexed By
240 IDD Cobol Indexed By
241 Module
242 Module Text
243 .Assembler Module
244 .Cobol Module
245 .Culprit Module
246 .DC Module
247 .OCF Module
248 .OLQ Module
249 .PL/I Module
250 .Process Module
251 Segment
252 File
253 Area in File
254 DMCL using File
255 Area
256 File in Area
257 DMCL using Area
258 Schema using Area as default
259 Table stored in Area
260 Index stored in Area
261 Symbolic Parameter
262 Subarea
263 Displacement
264 Index
265 Grantee on Area
266 Grantee for DBAREAD
267 Grantee for DBAWRITE
268 Grantee for Use
269 DMCL including Segment
270 DBName including Segment
271 Schema referencing Segment
272 Grantee for Segment
273-279 Grantees
280 DBTable
281 Subschema Mapping
282 DBName
283 Segment in DBName
284 Subschema Mapping in DBName
285 Schema referencing DBName
286 DBTable including DBName
287 Grantee for DBName
288-294 Grantees
295 DMCL using DBTable
296 DBGroup in DBTable
297 Grantee for DBTable
298-303 Grantees
304 DMCL
305 Segment in DMCL
306 Segment.File Override
307 Segment.Area Override
308 File in DMCL
309 Area in DMCL
310 Shared File in DMCL
311 Shared Area in DMCL
312 Shared Cache in DMCL
313 Buffer
314 Database Buffer
315 Journal Buffer
316 Journal
317 Archive Journal
318 Disk Journal
319 Tape Journal
320 Grantee for DMCL
321-326 Grantees
327 System
328 Load List
329 Component of Loadlist
330 Program
331 Queue
332 Autotask
333 Task
334 Storage Pool
335 XA Storage Pool
336 Line
337 Pterm in Line
338 Lterm in Pterm
339 Lterm in Line
340 Pterm
341 Lterm
342 Printer
343 Destination
344 Lterm in Destination
345 Printer in Destination
346 User in Destination
347 Node
348 Resource Table
349 Local Dictionary in Res Table
350 Dictionary via Node in Res Table
351 Destination Node in Res Table
352 Rununit
353 Map Table
354 Entry of Map Table
355 Key Table
356 Application
357 SQL Cache
358 Except Connect Name
359 TCP/IP
360 Stack
361 Except
362 System Resource & Profile
363 Category
364 Access Module in Category
365 Load Module in Category
366 Program in Category
367 Queue in Category
368 Rununit in Category
369 Task in Category
370 Grantee for Execute
371 Activity
372 Grantee for Execute
373 System Id
374 Signon System Profile.User
375 Grantee for System Id
376-381 Grantees
382 System Profile
383 Attribute
384 Signon System Id.User
385 Grantee on System Profile
386-390 Grantees
391 User Profile
392 Attribute
393 Grantee on User Profile
394-398 Grantees
399 Group
400 User in Group
401 Privilege for Group
402 Access Module granted
403-408 Privileges
409 Activity granted
410 Area granted
411-413 Privileges
414 Category granted
415 DBName & Segment granted
416-422 Privileges
423 DBTable granted
424-429 Privileges
430 DCADMIN granted ?
431 DMCL granted
432-437 Privileges
438 Group granted
439-443 Privileges
444 Non SQL Schema granted
445 Privilege for Use
446 Non SQL Table granted
447-452 Privileges
453 Schema granted
454-459 Privileges
460 SYSADMIN granted ?
461 System Id granted
462-467 Privileges
468 System Profile granted
469-473 Privileges
474 Table granted
475-486 Privileges
487 Table Procedure granted
488-498 Privileges
499 Procedure granted
500-510 Privileges
511 Function granted
512-522 Privileges
523 User granted
524-528 Privileges
529 User Profile granted
530-534 Privileges
535 View granted
536-546 Privileges
547 Grantee on Group
548-552 Grantees
553 Central User
554 Group User belongs
555 Signon System Id.System Profile
556 Privilege for User
557 Access Module granted
558-563 Privileges
564 Activity granted
565 Area granted
566-568 Privileges
569 Category granted
570 DBName & Segment granted
571-577 Privileges
578 DBTable granted
579-584 Privileges
585 DCADMIN granted ?
586 DMCL granted
587-592 Privileges
593 Group granted
594-598 Privileges
599 Non SQL Schema granted
600 Privilege for Use
601 Non SQL Table granted
602-607 Privileges
608 Schema granted
609-614 Privileges
615 SYSADMIN granted ?
616 System Id granted
617-622 Privileges
623 System Profile granted
624-628 Privileges
629 Table granted
630-641 Privileges
642 Table Procedure granted
643-653 Privileges
654 Procedure granted
655-665 Privileges
666 Function granted
667-677 Privileges
678 User granted
679-683 Privileges
684 User Profile granted
685-689 Privileges
690 View granted
691-701 Privileges
702 Grantee on User
703-707 Grantees
708 Dictionary User
709 ntity Type Authority
710 Authority on Password
711 Authority on Culprit
712 Authority on OLQ
713 Authority on ADS
714 Authority on Load Module
715 Authority on Class Attribute
716 Authority on Class
717 Authority on Attribute
718 Authority on DC
719 Authority on Destination
720 Authority on Line
721 Authority on Logical-terminal
722 Authority on Map
723 Authority on Message
724 Authority on Panel
725 Authority on Physical-terminal
726 Authority on Queue
727 Authority on Task
728 Authority on IDD
729 Authority on Element
730 Authority on Entry Point
731 Authority on File
732 Authority on Module
733 Authority on Process
734 Authority on Qfile
735 Authority on Table
736 Authority on Program
737 Authority on Record
738 Authority on Report
739 Authority on Transaction
740 Authority on System
741 Authority on User
742 Authority on Idms
743 Authority on Schema
744 Authority on Subschema
745 Authority on All
746 Registration for Dictionary User
747 Non SQL Schema registered
748 Registration for All
749 Registration for .Update
750 Registration for ..Delete
751 Registration for ..Modify
752 Registration for ...Display
753 Registration for Public Access
754 Subschema registered
755 Registration for All
756 Registration for .Update
757 Registration for ..Delete
758 Registration for ..Modify
759 Registration for ...Display
760 Registration for Public Access
761 Responsibility of Dictionary User
762 Non SQL Schema responsibility
763 Responsibility for Creation
764 Responsibility for Deletion
765 Responsibility for Update
766 Responsibility for None
767 Subschema responsibility
768 Responsibility for Creation
769 Responsibility for Deletion
770 Responsibility for Update
771 Responsibility for None
772 Grantee for Administration
773 Grantee for DCADMIN
774 Grantee for SYSADMIN
775 CV DBTable
776 CV Subschema Mapping
777 CV DBName
778 CV Segment in DBName
779 CV Subschema Mapping in DBName
780 CV DBGroup
781 CV Backend in DBGroup
782 CV DMCL
783 CV Segment
784 CV File in Segment
785 CV Area in Segment
786 CV DBName including Segment
787 CV File
788 CV Area
789 SMP Space Report
790 SMP Avail. Space Distribution
791 SMP File Space Report
792 SMP Avail. Space Distribution
793 Full Space Report
794 Avail. Space Distribution
795 Record Space Distribution
796 File Space Report
797 Avail. Space Distribution
798 CV Database Buffer
799 CV Journal Buffer
800 CV Journal
801 CV System
802 CV Load List
803 CV Program
804 CV Program Module
805 CV Program Pool new Sysgen
806 CV Reent Prog Pool new Sysgen
807 CV Queue
808 CV Task
809 CV Storage Pool
810 CV XA Storage Pool
811 CV XA Storage Pool new Sysgen
812 CV Line
813 CV PTerm in Line
814 CV LTerm in Line
815 CV TCP/IP Info
816 CV Line new Sysgen
817 CV Pterm
818 CV Lterm
819 CV Printer
820 CV Destination
821 CV Node
822 CV Resource Table
823 CV Rununit
824 CV Rununit Detail
825 CV SQL Cache
826 CV Except Connect Name
827 CV TCP/IP
828 Services
829 Stacks
830 SYSIDMS
831 Activity
832 Active Program
833 Active Program Detail
834 Active Queue
835 Active Storage
836 Active Storage Detail
837 Active Task
838 Active Task Detail
839 Lterm using Scratch
840 User signed on
841 Search Log
842 Message in Log
843 Snap/Dump in Log
844 Trace in Log
845 Central Version
846 Autotune
847 Change Tracking
848 Change Tracking Files
849 Data Sharing Summary
850 Data Sharing Group Member
851 Data Sharing LIST Structure
852 Data Sharing LOCK Structure
853 Distributed Resource Manager
854 Dist Resource Manager Detail
855 Distributed Transaction
856 Dist Transaction Detail
857 Deadlock
858 DCMT Command Outstanding
859 External Rununit
860 Journal Status
861 Pending Transactions
862 Lock on Area
863 Lock on Lterm
864 Log
865 Log Driver
866 Shared Cache
867 File in Shared Cache
868 SQL Cache Content
869 SQL Cache Entry
870 Trace DB
871 Transaction
872 Transaction Sharing
873 DC
874 ADSO
875 DDS Lines
876 DDS PTerms
877 PTerms Attributes
878 Limit
879 Loadlib
880 LU
881 Modeent of LU
882 MPMode
883 MT Queue Depth
884 Nucleus Reload
885 Reply pending
886 Report Class/Destination
887 Report
888 Scratch
889 SNA Pterm
890 Snap
891 SubTask
892 TCP/IP Sockets
893 Time
894 Time initiated Task
895 Trace System
896 UCF Terminal
897 Statistics
898 Statistics Segment
899 Statistics File in Segment
900 Statistics Area in Segment
901 Statistics File
902 Statistics Area
903 Statistics Buffer
904 Statistics Interval
905 Statistics Roll
906 Statistics Lock
907 Statistics System
908 Statistics TCP/IP
Notes:
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |