International Business Machines Corporation

Jeffrey G Fontaine

Richard V Tran

Kevin D Hite

Justin A Danielson

Judy Y Tse

Betty J Patterson

Francis Joseph Ricchio

Anuradha V Vakkalagadda

Dean Lynn Grover

Claudia S Ho

A computer-implemented method includes receiving, via original Data Definition Language (DDL) syntax of a Database Management System (DBMS), a definition of custom DDL syntax. Metadata describing the custom DDL syntax is stored in a global catalog of the DBMS. A first DDL statement that utilizes the custom DDL syntax is received. The metadata describing the custom DDL syntax is read from the global catalog. The first DDL statement is processed, using a computer processor, according to the metadata.

Dynamically adding custom data definition language syntax to a database management system

A computer determines that the type of one or more of a relational operator and operands of a relational expression originated in a first type system, and determines the sign of at least one of the operands. The computer rewrites the relational expression based on the sign of at least one of the operands, sends the rewritten relational expression for evaluation in a second type system, and receives the evaluated rewritten relational expression after evaluation in the second type system. The computer can rewrite the relational expression by generating a group of terms joined disjunctively, as well as by generating a group of conjunctive terms joined disjunctively.

Rewriting relational expressions for different type systems

Rewriting  relational expressions for different type systems

An apparatus, system, and method for autonomously maintaining a single system image in a parallel systems complex. A computer program product causes the relevant systems in a parallel systems complex to receive requests with a global scope from a user. The request is sent to each IMS system in the sysplex, and each IMS system applies the resource information and logs the resource information for recovery. The request is written to a shared medium which IMS sysplex members can access. When an IMS member is brought online, the IMS member restores status information first from local recovery logs. The IMS member then checks the information against the global medium to determine if requests were issued while the IMS was offline. If so, the IMS inherits the information in the global medium before processing work. An IMS added into the sysplex applies the information from the global medium before processing work.

Apparatus, system, and method for autonomously maintaining a single system image in a parallel systems complex

Growing community of inventors

San Jose, CA, United States of America

Jeffrey G Fontaine