IBM DB2 for i is also called DB2 UDB for AS400, DB2 for iSeries etc. It's a relational database build into IBM i platform. IBM i platform one of the operating systems supported on IBM Power Systems alongside AIX and Linux and on IBM PureSystems alongside AIX, Linux and Windows. There are over 100,000 IBM i customer in 115 countries [2].
A traditional means of describing data attributes (such as the names and lengths of records and fields) is to specify the data attributes in the application programs themselves. Data description specifications (DDS) describes data attributes in file descriptions that are external to the application program that processes the data. |
To understand DB2 for i, the followings are the key concepts:
- OS: is the Database
- Libraries: are Schemas.
- Files: are Tables.
- Journal: are Redo Logs. There can be one or more journals per database and transactions can span multiple journals.
- Create one or more journal receivers. Use the Create Journal Receiver (CRTJRNRCV) command.
- Create a journal: Use the Create Journal (CRTJRN) command.
- Start journaling the file: Use the Start Journal Physical File (STRJRNPF) command.
Resources
- Ron Turull, The ins and outs of journaling -- Part I, Part II, Part IV 2005
- Steve Will, You and i Are Not Alone, 2010
- IBM i Strategy and Roadmap
- IBM i Documentation
- IBM i Product Home Page
- COMMON: The IBM Power Systems User Group
Created 4/12/2014