https://forums.mysql.com/profile.php?35,10100769
MySQL :: MySQL Forums :: Database Administration & Monitoring
database administrationmysqlforumsmonitoring
https://learn.oracle.com/ols/favorites/56098
Oracle Database Administration Student Subscription | Learn Oracle | Oracle Training and...
A complete learning subscription for Database Administrators. The Database Administration Student subscription includes content for the install and upgrade to...
oracle databasestudent subscriptionadministrationlearntraining
https://www.ibm.com/docs/en/ims/15.3.0?topic=security-restricting-scope-data-access
IMS 15.3 - Database administration - Restricting the scope of data access
You can restrict a user's access to (and even knowledge of) elements of a database by limiting the view of a database that you define for an application...
database administrationthe scopeims
https://www.ibm.com/docs/en/ims/15.3.0?topic=databases-dedb-insert-algorithm
IMS 15.3 - Database administration - DEDB insert algorithm
The DEDB insert algorithm searches for additional space when space is not available in the most desirable block.
database administrationimsinsertalgorithm
https://www.ibm.com/docs/en/ims/15.5.0?topic=buffers-options-improving-vsam-buffer-performance
IMS 15.5 - Database administration - Options for improving VSAM buffer performance
You can make a number of adjustments to improve the performance of VSAM buffers.
database administrationims
https://www.ibm.com/docs/en/ims/15.5.0?topic=databases-database-administration-tasks
IMS 15.5 - Database administration - Database administration tasks
The database administration tasks relevant to IMS databases are listed in this topic.
database administrationimstasks
https://forums.mysql.com/profile.php?35,17538733
MySQL :: MySQL Forums :: Database Administration & Monitoring
database administrationmysqlforumsmonitoring
https://www.ibm.com/docs/en/ims/15.2.0?topic=functions-summary-ims-database-types
IMS 15.2 - Database administration - Summary of IMS database types and functions
The following table provides a summary of characteristics, functions, and options of the different types of IMS databases.
database administrationimssummarytypesfunctions
https://www.ibm.com/docs/en/ims/15.6.0?topic=formats-lchild-segment-type-format
IMS 15.6 - Database administration - LCHILD segment type format
The IMS catalog LCHILD segment type contains information about a relationship between segment types.
database administrationsegment typeimsformat
https://www.ibm.com/docs/en/ims/15.4.0?topic=haldb-deleting-database-information-from-recon-data-set
IMS 15.4 - Database administration - Deleting the database information from the RECON data set
Delete database information for each logically related database from the RECON data sets.
database administration
https://www.ibm.com/docs/en/ims/15.3.0?topic=development-code-inspection-2
IMS 15.3 - Database administration - Code inspection 2
The objective of the second code inspection is to make sure module logic matches pseudo code or flowcharts. Interface and register conventions along with the...
database administrationcode inspectionims
https://www.ibm.com/docs/en/ims/15.5.0?topic=indexes-how-sparse-indexing-suppresses-index-entries
IMS 15.5 - Database administration - How sparse indexing suppresses index entries
When a source segment is loaded, inserted, or replaced in the database, DL/I automatically creates or maintains the pointer segment in the index. This happens...
database administrationims
https://www.sedatasolutions.io/
Database Administration (DBA) Consulting Services | Soaring Eagle Data Solutions
Data Solutions and Data Support For SMB and SME businesses in Florida and USA. SQL, Oracle, Cloud, Azure, AWS, PowerBi solutions based in Tampa Florida....
database administrationconsulting servicessoaring eagledbasolutions
https://www.mydbanotes.com/
My notes on Oracle Database Administration -- Moid
my notesoracle databaseadministrationmoid
https://www.ibm.com/docs/en/ims/15.5.0?topic=sets-changing-haldb-data-set-name-prefixes
IMS 15.5 - Database administration - Changing HALDB data set name prefixes
The data set name prefix for each partition is stored in the RECON data set. You can change it using either the HALDB Partition Definition utility (%DFSHALDB)...
database administrationims
https://www.ibm.com/docs/en/ims/15.1.0?topic=databases-maximum-sizes-hd
IMS 15 - Database administration - Maximum sizes of HD databases
The maximum possible size of HDAM, PHDAM, HIDAM, and PHIDAM databases is based on the number of data sets the database can hold and the size of the data sets....
database administrationimsmaximumsizeshd
https://www.dbagenesis.com/
DBA Genesis - Database Administration Courses
Learn to administer some of the world's biggest oracle databases. Explore DBA Genesis easy-to-follow oracle dba training, access all our course material,...
database administrationdbagenesiscourses
https://www.ibm.com/docs/en/ims/15.6.0?topic=utility-database-pcb-statement
IMS 15.6 - Database administration - The database PCB statement
The database PCB statement defines the DBD of the database that the application program will access.
database administrationimspcbstatement
https://www.ibm.com/docs/en/ims/15.5.0?topic=options-buffer-handler
IMS 15.5 - Database administration - The buffer handler
When a buffer is needed, an internal component called the buffer handler selects the buffer at the bottom of the use chain, because buffers that are least...
database administrationimsbufferhandler
https://lists.wikimedia.org/hyperkitty/list/wikimedia-l@lists.wikimedia.org/thread/MQIWZAKWYFKXWUPWWDF6XGD3WRQIYP2D/
Database administration support (was Re: IRC office hours: Shared hosting) - Wikimedia-l -...
database administration
https://www.ibm.com/docs/en/ims/15.6.0?topic=tables-dropping-column
IMS 15.6 - Database administration - Dropping a column
You can drop a column by using the ALTER TABLE statement with a DROP COLUMN clause. Only one DROP COLUMN clause is supported in an ALTER TABLE statement. To...
database administrationimsdroppingcolumn
https://www.ibm.com/docs/en/ims/15.6.0?topic=alter-setting-altersze-values-haldb
IMS 15.6 - Database administration - Setting ALTERSZE values for HALDB alter
To increase the OSAM block size or VSAM CI size of the database data sets when you are modifying the structure of a database with the HALDB alter function, you...
database administrationims
https://www.ibm.com/docs/en/ims/15.1.0?topic=database-altering-shared-haldb-databases
IMS 15 - Database administration - Altering shared HALDB databases
In a data-sharing environment, alter processing can be distributed among multiple IMS systems by routing the INIT OLREORG OPTION(ALTER) command to each of the...
database administrationimsalteringshareddatabases
https://forums.mysql.com/profile.php?35,172149
MySQL :: MySQL Forums :: Database Administration & Monitoring
database administrationmysqlforumsmonitoring
https://philipmcclarence.com/
Database Administration, Database Contractor
Oracle Consulting and Database Administration Advice and Guidance.
database administrationcontractor
https://www.ibm.com/docs/en/ims/15.5.0?topic=formats-psbvend-segment-type-format
IMS 15.5 - Database administration - PSBVEND segment type format
The IMS catalog PSBVEND segment type contains a short header followed by a large block of unformatted space.
database administrationsegment typeimsformat
https://www.ibm.com/docs/en/ims/15.1.0?topic=copies-nonstandard-image-copy-data-sets
IMS 15 - Database administration - Nonstandard image copy data sets
Image copy data sets that are not created by using one of the IMS image copy utilities are referred to as nonstandard image copy data sets or user image copy...
database administrationimsnonstandardimagecopy
https://www.ibm.com/docs/en/ims/15.4.0?topic=indexes-making-keys-unique-using-system-related-fields
IMS 15.4 - Database administration - Making keys unique using system related fields
If creating unique keys by keeping additional information from the source segment in the subsequence field of the pointer segment does not work for you, there...
database administration
https://www.ibm.com/docs/en/ims/15.2.0?topic=indexes-using-secondary-logical-relationships
IMS 15.2 - Database administration - Using secondary indexes with logical relationships
You can use secondary indexes, except for Fast Path secondary indexes, with logical relationships.
database administrationims
https://www.ibm.com/docs/en/ims/15.6.0?topic=implementation-developing-test-databases
IMS 15.6 - Database administration - Developing test databases
Before the application programs accessing your database are transferred to production status, they must be tested. To avoid damaging a production database, you...
database administrationimsdevelopingtestdatabases
https://www.ibm.com/docs/en/ims/15.4.0?topic=spaces-dropping-table-space
IMS 15.4 - Database administration - Dropping a table space
You can remove an existing table space by issuing a DROP TABLESPACE statement. This can be useful if you plan to change the table space name or plan to...
database administrationimsdroppingtablespace
https://www.ibm.com/docs/en/ims/15.2.0?topic=indexes-making-keys-unique-using-system-related-fields
IMS 15.2 - Database administration - Making keys unique using system related fields
If creating unique keys by keeping additional information from the source segment in the subsequence field of the pointer segment does not work for you, there...
database administration
https://www.ibm.com/docs/en/ims/15.3.0?topic=formats-case-segment-type-format
IMS 15.3 - Database administration - CASE segment type format
The IMS catalog CASE segment type contains information about a specific case for a mapping of an IMS database segment.
database administrationsegment typeimscaseformat
https://www.ibm.com/docs/en/ims/15.1.0?topic=dpfehd-considerations-deleting-partition-from-haldb-database-that-uses-secondary-index
IMS 15 - Database administration - Considerations for deleting a partition from a HALDB database...
If there a HALDB database uses a secondary index, you must be careful when you delete a partition.
database administrationimsconsiderations
https://www.ibm.com/docs/en/ims/15.1.0?topic=relationships-defining-sequence-fields-logical
IMS 15 - Database administration - Defining sequence fields for logical relationships
When you use logical relationships, certain rules and recommendations should be followed when defining sequence fields.
database administrationimsdefiningsequencefields
https://www.ibm.com/docs/en/ims/15.1.0?topic=option-defining-vso-dedb-area
IMS 15 - Database administration - Defining a VSO DEDB area
All of the Virtual Storage Option (VSO) information for a DEDB is recorded in the RECON data set.
database administrationimsdefiningvsoarea
https://www.ibm.com/docs/en/ims/15.1.0?topic=hphpd-replacing-segments
IMS 15 - Database administration - Replacing segments
Replacing segments in HD databases is straightforward as long as fixed-length segments are used.
database administrationimsreplacingsegments
https://forums.mysql.com/profile.php?35,11078657
MySQL :: MySQL Forums :: Database Administration & Monitoring
database administrationmysqlforumsmonitoring
https://www.ibm.com/docs/en/ims/15.6.0?topic=hssp-benefits-function
IMS 15.6 - Database administration - Benefits of the HSSP function
The high-speed sequential processing (HSSP) function provides a number of benefits.
database administrationbenefits ofimsfunction
https://www.ibm.com/docs/en/ims/15.1.0?topic=dedbs-dedb-design-guidelines
IMS 15 - Database administration - DEDB design guidelines
The following list describes guidelines for designing DEDBs.
database administrationimsdesignguidelines
https://www.ibm.com/docs/en/ims/15.1.0?topic=types-converting-database-from-hisam-hidam
IMS 15 - Database administration - Converting a database from HISAM to HIDAM
Converting a database from HISAM to HIDAM can be performed in a few steps; however, you need to perform a number of preliminary steps also.
database administrationimsconverting
https://forums.mysql.com/profile.php?35,10592094
MySQL :: MySQL Forums :: Database Administration & Monitoring
database administrationmysqlforumsmonitoring
https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Spanner.Admin.Database.V1/latest/Microsoft.Extensions.DependencyInjection.ServiceCollectionExtensions
Google Cloud Spanner Database Administration v1 API - Class ServiceCollectionExtensions...
google cloud spannerdatabase administrationapiclass
https://www.novell.com/documentation/zenworks-service-desk-24.3/admin/data/c000124.html
Database - Administration Guide
database administrationguide
https://www.ibm.com/docs/en/ims/15.6.0?topic=program-loading-gsam-database
IMS 15.6 - Database administration - Loading a GSAM database
GSAM databases use logical records, not segments or database records. GSAM logical records are stored in the order in which you present them to the load...
database administrationimsloadinggsam
https://www.ibm.com/docs/en/ims/15.3.0?topic=environment-overflow-buffer-allocation-bmps
IMS 15.3 - Database administration - Overflow buffer allocation for BMPs
Overflow buffer allocation for BMPs is optional and is used for exceptional buffer requirements when the normal buffer allocation has been exhausted.
database administrationimsoverflowbufferallocation
https://www.ibm.com/docs/en/ims/15.2.0?topic=phidam-image-copying-database-data-sets
IMS 15.2 - Database administration - Image copying the database data sets
The reload process sets the image copy needed flag for each database data set other than ILDSs and PHIDAM primary indexes.
database administrationimsimagecopyingsets
https://www.ibm.com/docs/en/ims/15.6.0?topic=dedbs-examples-defining-segments
IMS 15.6 - Database administration - Examples of defining segments
The following examples show how to use the BYTES= parameter to define variable-length or fixed-length segments.
database administrationexamples ofimsdefiningsegments
https://www.ibm.com/docs/en/ims/15.6.0?topic=databases-general-naming-conventions-ims
IMS 15.6 - Database administration - General naming conventions for IMS databases
Naming conventions help users identify and manage the many resources in an IMS system. Some naming conventions are defined by IMS, while many others can be...
database administrationnaming conventionsimsgeneraldatabases
https://www.ibm.com/docs/en/ims/15.2.0?topic=utility-dbd-statement-overview
IMS 15.2 - Database administration - DBD statement overview
In the input, the DBD statement names the database being described and specifies various attributes including its organization and its exit routines, if any.
database administrationimsdbdstatementoverview
https://www.ibm.com/docs/en/ims/15.6.0?topic=reorganization-locking-impacts-haldb-online
IMS 15.6 - Database administration - Locking impacts of HALDB Online Reorganization
To maintain partition integrity and recoverability during an online reorganization of a HALDB partition, HALDB Online Reorganization requests a very large...
database administrationims
https://www.ibm.com/docs/en/ims/15.5.0?topic=indexes-example-defining-secondary
IMS 15.5 - Database administration - Example of defining secondary indexes
The secondary index in this example is used to retrieve COURSE segments based on student names.
database administrationexample ofimsdefiningsecondary
https://www.ibm.com/docs/en/ims/15.2.0?topic=administration-database-design-implementation
IMS 15.2 - Database administration - Database design and implementation
This section discusses the design and implementation of IMS databases, including analyzing your data requirements, planning, designing, and implementing each...
database administrationimsdesignimplementation
https://www.ibm.com/docs/en/ims/15.6.0?topic=databases-hierarchical-forward-pointers
IMS 15.6 - Database administration - Hierarchical forward pointers
With hierarchical forward (HF) pointers, each segment in a database record points to the segment that follows it in the hierarchy.
database administrationimshierarchicalforwardpointers
https://www.ibm.com/docs/en/ims/15.3.0?topic=databases-correcting-bad-pointers
IMS 15.3 - Database administration - Correcting bad pointers
Ordinarily, bad pointers should not occur in your database. When they do, the likely causes are few.
database administrationimscorrectingbadpointers
https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Spanner.Admin.Database.V1/latest/Google.Cloud.Spanner.Admin.Database.V1.ListDatabaseRolesRequest
Google Cloud Spanner Database Administration v1 API - Class ListDatabaseRolesRequest...
google cloud spannerdatabase administrationapiclass
https://www.ibm.com/docs/en/ims/15.4.0?topic=sets-naming-convention-haldb-data-set-names
IMS 15.4 - Database administration - Naming convention for HALDB data set names
You define a part of HALDB data set names and IMS creates the rest.
database administrationnaming convention
https://www.ibm.com/docs/en/ims/15.3.0?topic=sensitivity-using-field-level-logical-relationships
IMS 15.3 - Database administration - Using field-level sensitivity with logical relationships
You must follow some rules when using field-level sensitivity with segments that are involved in a logical relationship
database administration
https://www.ibm.com/docs/en/ims/15.3.0?topic=utilities-recovery-after-image-copy
IMS 15.3 - Database administration - Recovery after image copy
The Database Image Copy utility (DFSUDMP0) and the Database Image Copy 2 utility (DFSUDMT0) copy data sets for HISAM, HIDAM, HDAM, PHDAM, PHIDAM databases, and...
database administrationafter imageimsrecoverycopy
https://www.ibm.com/docs/en/ims/15.6.0?topic=routines-call-sequence-data-capture-exit
IMS 15.6 - Database administration - Call sequence of Data Capture exit routines
A Data Capture exit routine is invoked once per segment update for each segment for which the Data Capture exit routine is specified. Data Capture exit...
database administration
https://www.ibm.com/docs/en/ims/15.3.0?topic=statements-defining-dynamic-array-ims
IMS 15.3 - Database administration - Defining a dynamic array to IMS
A dynamic array is an array in which the number of repeating array elements can vary from one instance of a segment type to another.
database administrationdynamic arrayimsdefining
https://docs.cloud.google.com/dotnet/docs/reference/Google.Cloud.Spanner.Admin.Database.V1/latest/Google.Cloud.Spanner.Admin.Database.V1.ListBackupOperationsRequest
Google Cloud Spanner Database Administration v1 API - Class ListBackupOperationsRequest...
google cloud spannerdatabase administrationapiclass
https://www.ibm.com/docs/en/ims/15.5.0?topic=database-haldb-alter-offline-reorganization
IMS 15.5 - Database administration - HALDB alter and offline reorganization
After starting HALDB alter on a database, if the alter operation is terminated, you can complete the application of the DBD changes to the database by using...
database administrationimsalterofflinereorganization
https://www.ibm.com/docs/en/ims/15.1.0?topic=utilities-partial-offline-reorganization
IMS 15 - Database administration - Partial offline reorganization
If you are reorganizing an HD database, you can reorganize parts of it, rather than the whole database.
database administrationimspartialofflinereorganization
https://www.oncalldba.com.au/
OnCall DBA | Database Administration Services Perth
database administrationoncalldbaservicesperth
https://www.ibm.com/docs/en/ims/15.5.0?topic=indexes-dedb-partitioned-secondary
IMS 15.5 - Database administration - DEDB partitioned secondary indexes
DEDB partitioned secondary indexes allow a DEDB secondary index to be spread across multiple physical databases. A maximum of 101 user partition databases per...
database administrationimspartitionedsecondaryindexes
https://www.ibm.com/docs/en/ims/15.4.0?topic=options-multiple-buffers-in-virtual-storage
IMS 15.4 - Database administration - Multiple buffers in virtual storage
You can specify both the number of buffers needed in virtual storage and their size. You can specify multiple buffers with different sizes.
database administrationimsmultiplebuffersvirtual
https://www.ibm.com/docs/en/ims/15.2.0?topic=databases-general-naming-conventions-ims
IMS 15.2 - Database administration - General naming conventions for IMS databases
Naming conventions help users identify and manage the many resources in an IMS system. Some naming conventions are defined by IMS, while many others can be...
database administrationnaming conventionsimsgeneraldatabases
https://www.ibm.com/docs/en/ims/15.2.0?topic=databases-osam-options
IMS 15.2 - Database administration - OSAM options
Two types of options are available for databases using OSAM.
database administrationimsosamoptions
https://www.ibm.com/docs/en/ims/15.2.0?topic=formats-mar-segment-type-format
IMS 15.2 - Database administration - MAR segment type format
The IMS catalog MAR segment type contains information about a field marshaller definition in an IMS database.
database administrationsegment typeimsmarformat
https://www.ibm.com/docs/en/ims/15.1.0?topic=mod-activating-database-changes-by-using-online-change-function
IMS 15 - Database administration - Activating database changes by using the online change function
In IMS systems that use DBD, PSB and ACB libraries, you can use the online change function to apply database changes, including changes to full-function...
database administration
https://www.ibm.com/docs/en/ims/15.5.0?topic=set-additional-considerations-partition-definition-control-blocks
IMS 15.5 - Database administration - Additional considerations for the partition definition control...
When making changes to HALDB partition definitions, until the online partition definition control blocks are rebuilt, a number of circumstances could occur...
database administrationadditional considerations
https://forums.mysql.com/profile.php?35,11276089
MySQL :: MySQL Forums :: Database Administration & Monitoring
database administrationmysqlforumsmonitoring
https://www.ibm.com/docs/en/ims/15.2.0?topic=catalog-overview-ims
IMS 15.2 - Database administration - Overview of the IMS catalog
The IMS catalog contains trusted metadata and definitions of the IMS databases and application program views that are defined to IMS.
database administrationoverview ofimscatalog
https://www.ibm.com/docs/en/ims/15.5.0?topic=segments-replacing-partially-present-fields
IMS 15.5 - Database administration - Replacing partially present fields
When replacing partially present fields be aware of the following points.
database administrationimsreplacingpartiallypresent
https://www.ibm.com/docs/en/ims/15.1.0?topic=databases-database-administration-tasks
IMS 15 - Database administration - Database administration tasks
The database administration tasks relevant to IMS databases are listed in this topic.
database administrationimstasks
https://learn.oracle.com/ols/course/prepare-for-oracle-database-administration-i-certification/42305/79688/
Prepare for Oracle Database Administration I Certification | Learn Oracle | Oracle Training and...
Prepare for Oracle Database Administration I certification using sample questions and a practice exam with pointers to useful resources.
prepare fororacle databaseadministrationcertificationlearn
https://www.ibm.com/docs/en/ims/15.2.0?topic=formats-arearmk-segment-type-format
IMS 15.2 - Database administration - AREARMK segment type format
The IMS catalog AREARMK segment type contains user comments about a database area definition for a Fast Path database.
database administrationsegment typeimsformat
https://www-cloudfront-alias.coursera.org/specializations/packt-oracle-database-administration-from-zero-to-hero
Oracle Database Administration from Zero to Hero | Coursera
Offered by Packt. Master Oracle Database Administration Skills. Learn to configure, manage, and optimize Oracle databases, perform backups ... Enroll for free.
from zero to herooracle databaseadministrationcoursera
https://www.ibm.com/docs/en/ims/15.3.0?topic=record-determining-segment-frequency
IMS 15.3 - Database administration - Determining segment frequency
After you have determined the total size of a segment type, you need to determine segment frequency.
database administrationimsdeterminingsegmentfrequency
https://www.ibm.com/docs/en/ims/15.3.0?topic=formats-sfrmk-segment-type-format
IMS 15.3 - Database administration - SFRMK segment type format
The IMS catalog SFRMK segment type contains user comments for a sensitive field definition.
database administrationsegment typeimsformat
https://www.ibm.com/docs/en/ims/15.6.0?topic=utilities-offline-reorganization-by-using-reorganization
IMS 15.6 - Database administration - Offline reorganization by using the reorganization utilities
If you do not use the Utility Control Facility (UCF), reorganization of a database is done using a combination of utilities. Which utilities you need to use,...
database administrationims
https://forums.mysql.com/profile.php?35,10723832
MySQL :: MySQL Forums :: Database Administration & Monitoring
database administrationmysqlforumsmonitoring
https://www.ibm.com/docs/en/ims/15.6.0?topic=vsam-no-free-logical-record-exists
IMS 15.6 - Database administration - No free logical record exists
This example shows how insertion takes place when no free logical record exists in the CI.
database administrationimsfreelogicalrecord
https://forums.mysql.com/profile.php?35,1966007
MySQL :: MySQL Forums :: Database Administration & Monitoring
database administrationmysqlforumsmonitoring
https://www.ibm.com/docs/en/ims/15.3.0?topic=relationships-logical-relationship-pointer-types
IMS 15.3 - Database administration - Logical relationship pointer types
In all logical relationships the logical child establishes a path between two segment types. The path is established by use of pointers.
database administrationimslogicalrelationshippointer
https://www.ibm.com/docs/en/ims/15.4.0?topic=review-general-information-about-reviews
IMS 15.4 - Database administration - General information about reviews
During system development, development groups typically hold a series of reviews that are common to most development projects.
database administrationgeneral informationimsreviews
https://www.ibm.com/docs/en/ims/15.5.0?topic=utilities-database-prefix-resolution-utility-dfsurg10
IMS 15.5 - Database administration - Database Prefix Resolution utility (DFSURG10)
You use the Prefix Resolution utility to accumulate and sort the information that has been put on DFSURWF1 work data sets up to this point in the load or...
database administrationimsprefixresolutionutility
https://learn.oracle.com/ols/course-list/56063
Courses | Oracle Database Administration Student Learning Subscription (Cloud Edition) | Learn...
View the list of available courses in the Oracle Database Administration Student Learning Subscription (Cloud Edition). Explore available beginner to advanced...
oracle databasestudent learningcloud editioncoursesadministration
https://www.ibm.com/docs/en/ims/15.6.0?topic=security-restricting-access-by-non-ims-programs
IMS 15.6 - Database administration - Restricting access by non-IMS programs
One potential security exposure is from people attempting to access IMS data sets with non-IMS programs. Two methods of protecting against this exposure are...
database administrationrestricting accessimsnonprograms
https://www.ibm.com/docs/en/ims/15.1.0?topic=haldb-allocating-psindex-vsam-ksds-data-sets
IMS 15 - Database administration - Allocating PSINDEX VSAM KSDS data sets
Allocate a VSAM KSDS data set for each partition of the PSINDEX by using the IDCAMS DEFINE statement.
database administrationimsvsamsets
https://www.ibm.com/docs/en/ims/15.5.0?topic=databases-open-database-access-odba
IMS 15.5 - Database administration - Open Database Access (ODBA)
Any program that runs in a z/OS address space can access IMS DB through the Open Database Access (ODBA) callable interface.
database administrationopen accessimsodba
https://www.ibm.com/docs/en/ims/15.4.0?topic=utilities-partial-offline-reorganization
IMS 15.4 - Database administration - Partial offline reorganization
If you are reorganizing an HD database, you can reorganize parts of it, rather than the whole database.
database administrationimspartialofflinereorganization
https://www.ibm.com/docs/en/ims/15.1.0?topic=buffers-adjusting-sequential
IMS 15 - Database administration - Adjusting sequential buffers
You can change the number of buffer sets allocated to each SB buffer pool in two ways.
database administrationimsadjustingsequentialbuffers
https://www.ibm.com/docs/en/ims/15.3.0?topic=utility-fast-path-log-reduction
IMS 15.3 - Database administration - Fast Path log reduction
To reduce log volume you can use the LGNR parameter, which is specified on the DBC, FDR, and IMS startup procedures.
database administrationimsfastpathlog
https://www.ibm.com/docs/en/ims/15.4.0?topic=relationships-secondary-indexes-versus-logical
IMS 15.4 - Database administration - Secondary indexes versus logical relationships
Both secondary indexes and logical relationships provide logical data structures, which are hierarchical data structures that are different from the data...
database administrationimssecondaryindexesversus
https://www.ibm.com/docs/en/ims/15.2.0?topic=types-converting-database-from-hisam-hdam
IMS 15.2 - Database administration - Converting a database from HISAM to HDAM
Converting a database from HISAM to HDAM can be performed in a few steps; however, you need to perform a number of preliminary steps also.
database administrationims
https://www.ibm.com/docs/en/ims/15.2.0?topic=databases-physical-child-first-pointers
IMS 15.2 - Database administration - Physical child first pointers
With physical child first (PCF) pointers, each parent segment in a database record points to the first occurrence of each of its immediately dependent child...
database administrationchild firstimsphysicalpointers
https://www.ibm.com/docs/en/ims/15.4.0?topic=implementation-designing-fast-path-databases
IMS 15.4 - Database administration - Designing Fast Path databases
After you determine the type of database and optional functions that best suit your application's processing requirements, you need to make a series of...
database administrationimsdesigningfastpath
https://forums.mysql.com/profile.php?35,2303106
MySQL :: MySQL Forums :: Database Administration & Monitoring
database administrationmysqlforumsmonitoring