Abstract: A computer system and a relational database management system (RDMS) computer program product are described for interfacing a number of concurrently running database sessions with a large database in which a plurality of local temporary object database descriptors are used in lieu of a single global temporary object database descriptor where the global and each of the local temporary object database descriptors include identifiers for temporary objects, each of the local temporary object database descriptors is associated with a single database session and each of the global database descriptors is shared among multiple database sessions.

Abstract: A method and system to manage temporary storage space of a relational database management system by receiving a data segment allocation request from an application, allocating a data segment to the application, marking the data segment as allocated in a space map page, and indicating a usage status of the data segment. The method also includes receiving a mass delete command from the application, indicating reception of the mass delete command in a table-related control block, and marking the data segment as unavailable in the space map page. The method may also include indicating reception of the mass delete commit command in the table-related control block to enable the application to reuse the data segment.

Abstract: Provided are a method, system, and program for managing a database. A request is processed to create an index on at least one key column of a table in a computer readable medium. A determination is made of table partitions in which rows of the table are stored. One index partition is generated for each determined table partition, wherein each index partition includes nodes, wherein each node in each index partition includes a key value from at least one column in a corresponding table row in the table partition associated with the index partition and a location identifier identifying the corresponding table row in the corresponding table partition. In certain embodiments, a technique is implemented during queries to limit the search to a subset of the multiple index partitions when possible and return rows in the order of the key columns of the index while the same range of key values can exist across multiple index partitions.

Abstract: A system, computer usable medium and computer-based method for altering a sequence number assignment pattern while preserving integrity and high concurrency in an environment having a plurality of applications on at least one computer system sharing a direct access storage device (DASD). The method generates and assigns sequence numbers for a shared sequence object located on the shared DASD to a plurality of applications executing concurrently and using the shared sequence object. When an application starts altering the shared sequence object attribute(s) during concurrent assignment of sequence numbers by other applications, it notifies all computer systems using the shared sequence object to locally refresh the sequence object attribute descriptor and discard unused reserved sequence numbers, and then updates the altered shared sequence object attribute and last assigned sequence number on the shared DASD.

Abstract: A system, computer usable medium and computer-based method for altering a sequence number assignment pattern while preserving integrity and high concurrency in an environment having a plurality of applications on at least one computer system sharing a direct access storage device (DASD). The method generates and assigns sequence numbers for a shared sequence object located on the shared DASD to a plurality of applications executing concurrently and using the shared sequence object. When an application starts altering the shared sequence object attribute(s) during concurrent assignment of sequence numbers by other applications, it notifies all computer systems using the shared sequence object to locally refresh the sequence object attribute descriptor and discard unused reserved sequence numbers, and then updates the altered shared sequence object attribute and last assigned sequence number on the shared DASD.

Abstract: Provided are a method, system, and program for managing a database. A request is processed to create an index on at least one key column of a table in a computer readable medium. A determination is made of table partitions in which rows of the table are stored. One index partition is generated for each determined table partition, wherein each index partition includes nodes, wherein each node in each index partition includes a key value from at least one column in a corresponding table row in the table partition associated with the index partition and a location identifier identifying the corresponding table row in the corresponding table partition. In certain embodiments, a technique is implemented during queries to limit the search to a subset of the multiple index partitions when possible and return rows in the order of the key columns of the index while the same range of key values can exist across multiple index partitions.