DB2

JCL/SDSF (spool)

• KR 1 - 4: Indexes in general and DB2 in particular
• KR 5 - 8: Optimizer - Cost, tablescans, indexed access
• KR 9 - 12: Tablespace, predicates, IKJEFT01, binding, DBRMs
• KR 13 - 18: Index scans and NMIS
• KR 26 - 27: DB projection, selection
• KR 31 - 32: Special names (cobol)
• KR 33 - 36: BMC for checking views
• KR 37: DSNTIAR
• KR 75 - 77: DB2 precompiler + DBRM + plans
• KR 78 - 79: DB2 joins
• KR 104-106: DB2 EXPLAINing itself!
• KR 107-111: Refresher on DB2, indexes and scans (reloaded KRs)
• KR 112-113: Optimizer costs
• KR 114-115: DB2 components + table scans
• KR 116-118: sequential prefetch + index access and cobol coding + some SQL
• KR 119-122: DB2 MIS + NMIS + more EXPLAIN
• KR 123-124: DB2 fetch clause
• KR 162 - DB2 SUBstring
• KR 163-165: -818 and 81Q (parts I-III)
• KR 166-168: -818 and 81Q (parts IV-VI)
• KR 204-206 Saving queries in QMF
• KR 230-232 Connecting to DB2 on mainframes from Windows using DB2 Connect

• KR 13 - 18: MVS, PDS compression
• KR 22 - 25: MVS/JCL + SMS + DISP
• KR 26 - 27: JCL IF statement
• KR 33 - 36: Saving the spool + A>0 or 0>A?
• KR 42 - 43: SMS part I and II
• KR 44 - 46: SMS classes + management classes
• KR 53 - 54: Duplicate jobs in spool + JCL listing in spool 
• KR 60 - 63: Submit a job from a job + Checking for empty dataset in a JCL
• KR 64 - 65: Appending datasets in JCL
• KR 73 - 74: EX command and IF in JCL
• KR 80 - 82: OUTLIM parm + email thro JCL + more linking
• KR 83 - 84: Recovering deleted files + dummy files
• KR 99-101: ISRDDN + IEBCOPY + which cobol compiler?
• KR 102-103 - Blocking
• KR 119-122: Mainframes aSLEEP!
• KR 125 - 127: Which is greater zero or spaces? + SYNCSORT line count 
• KR 128 - 130: JCL puzzle + FB and FBA
• KR 170-172 - SDSF
• KR 209-211 Counting number of records in a file

COBOL

TSO/INSYNC/General mainframes

• KR 31 - 32: Special names (cobol)
• KR 33 - 36: Is A>0 or 0>A?
• KR 55 - 57: COMPs in COBOL + HEX format
• KR 58 - 59: comp/comp4

• KR 93 - 96: COBOL pics I and II, COBOL numerics

• KR 97 - 98: Perform until?

  KR 99-101: Which cobol compiler?

  KR 158-159 - COBOL Puzzle

  KR 175-178 - COBOL Puzzle (edited Pic class)

• KR 189-190 MOVE CORRESPONDING; Redefining smaller by larger variable.
• KR 191-192 NEXT SENTENCE and CONTINUE

• KR 38 - 41: TSO tips - searching for special characters + appending datasets in 3.4
• KR 47 - 51: TSO tips - retp + sorting + bookmarks/labels + undeleting datasets + TSO mem command
• KR 58 - 59: WHOHAS
• KR 64 - 65: Source/object code
• KR 55 - 57: HEX format
• KR 66 - 68: linking + low level language + memories
• KR 69 - 71: Loader + linker + compiler
• KR 93 - 96: Cutting tips
• KR 97 - 98: TSO cutting tip
• KR 125 - 127: Recovering lost datasets
• KR 157,160,161 - MEM+SRCHFOR+COMP 
• KR 170-172 - SCRNAME + Personal lists
• KR 173-174 - RETrieve+SPLIT
• KR 179 - ALTER properties
• KR 180-182 - ASCII & BINARY
• KR 183 - ISPF (the dialog manager)
• KR 193-196 INSync commands: FREEZE, COLW, EXCLUDE, FS
• KR 197-200 INSync commands: HHOLD, SHOW88, LAYOUT, INDENT
• KR 201-203 TSO SEND command; Mapping TSO commands - I and II
• KR 204-206 Listing members in a PDS with wildcard
• KR 207-208 Print screen in mainframes and subcommands; Hotspot menu
• KR 209-211 Disabling the EDIT/VIEW entry panel
• KR 225-227 Personal data sets, EPC macros, size of a dataset

REXX tutorial

IMS

• KR 229-235 Digging into IMS - DIF, DOF, MID, MOD, DBD, PSB, PCB, ACB, MFS

Financial Management and accounting

Other miscellaneous topics (networking etc.)

• KR 85-88: Basics of a company (part 1 to 4)

• KR 89-92: Management refreshers (parts 5 to 8)

• KR 131-133: Management refreshers (part 9 to 11)

• KR 134-136: GAAP + balance sheets

• KR 137-139: Accrual + double entry accounting + credit =debit!

• KR 140-142: par=face! + more on balance sheet

• KR 143-146: P&L + debit=equity + hE BIT who?

• KR 147-150: CASH + cash flow + cash transactions

• KR 151: Ltd, PLC, LLC, Pvt. Ltd.

• KR 152-156: Cash flow statement

• KR 19 - 21: FTP (and mainframes FTP)

• KR 52: IP address and networking

• KR 184-186 FILter in SDSF; text editing commands; .ZF & .ZL and saving in VIEW mode
• KR 187-188 Internic I and II