5 keywords every developer and DBA should know

I am listing some of the most important terminology that every developer and DBA in the z/OS Mainframe world should know while interacting with IBM DB2. Most of the times a miss communication between a developer and a DBA can cause delays and account for each others precious time. I have tried to explain the key terms in the simplest possible way so that the vast majority of readers get used to the fact that, yes - indeed its necessary to know them

1) PRECOMPILE
Processes an application program source code ( ex : COBOL ) which contains SQL statements within EXEC and END-EXEC statements. Once you precompile you get a modified source code which will be your LOAD MODULE present in the LOADLIB PDS. This load module in the form of a member within your load library will contain host language calls for SQL statements.

2) DBRM
A member within your DBRM library containing all the SQL's extracted from source code by the precompiler. DBRM MODULE is present in the DBRMLIB PDS. The library name is very important as one might miss performing a BIND and will have no clue which DBRM library the BIND member was placed. As a developer, you should be able to provide the DBRM library used while performing PRECOMPILE

3) BIND
You need to perform the BIND operation to compile all your SQL statements (DBRM) into an executable format. A DBA may ask you which DBRMLIB you used while your precompiled and bound your program ? You should be able to provide the necessary details.

4) PACKAGE / PROGRAM
A DB2 Package is an object that contains executable forms of SQL statements. Basically if you are in DB2 10 for z/OS - All your application programs should be in the form of a package. It's a good practice to keep all your programs as a DB2 package

5) PLAN
An application PLAN can contain one or more packages or it can contain bound form of SQL statements. You need a PLAN to run/execute a package in DB2.

Summary
There are many other factors which every developer and DBA must know, but clear knowledge on these keywords can help reduce the time spent in conversations during job abends  !