skip to main
|
skip to sidebar
Techie_FAQ
Sunday, June 11, 2006
Quiesce tablespace
A QUIESCE flushes all DB2 buffers on the disk. This gives a correct snapshot of the database and should be used before and after any IMAGECOPY to maintain consistency.
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2009
(5)
►
December
(1)
LISTCAT command
►
September
(1)
Sort JCL - to replace 1st 2 characters
►
July
(3)
REXX: Parsing a stream with a delimiter
Listing datasets - ISPF command
REXX builtin function - WORDPOS
►
2008
(4)
►
November
(1)
Error message in IDCAMS step
►
August
(2)
PLI- %REPLACE
PLI - ONCODE built in function
►
January
(1)
What is CATMAINT utility
►
2007
(29)
►
December
(4)
IBM1936I S Invocation of compiler backend ended ab...
REXX - TRACE command
How do I test a ISPF panel?
ISRROUTE - ISPF command
►
November
(1)
DB2 datatype - DATE
►
October
(1)
RECFM for Print files
►
August
(4)
COND=ONLY in JCL
COND=EVEN in JCL
SQLCODE = 562
Handling NULL in the program
►
July
(5)
Packed datasets
Abend S013
SQLCODE = -204
SQLCODE = -679
SQL : Error handling : WHENEVER stmt
►
June
(1)
PLI: ENVIRONMENT(CTLASA)
►
May
(2)
SQLCODE = -401 SQLSTATE= 42818
SQLCODE = -181 SQLSTATE=22007
►
April
(5)
SQLCODE = -180 SQLSTATE= 22007
SQLCODE = -117
SQLCODE = -102
DB2: How does DB2 store NULL physically?
Common abends
►
January
(6)
What is Unicode?
What is an encoding scheme?
What is CCSID - Coded Character Set IDentifier?
What are Code pages?
What are Code points?
SQLCODE -922
▼
2006
(34)
►
November
(2)
IDCAMS - skip
To find the version
►
October
(1)
SQLCODE=-30080 / -904 - Conversation failure recov...
►
September
(1)
VERIFY in PL/1
►
August
(2)
System Abend: 0E37
System 806 Abend
►
July
(1)
SQLCODE -927
▼
June
(27)
DB2: Fun with dates and times
DYNAMNBR parm
Article on DBRM/Bind
DB2 V8 Multiple DISTINCT clauses
Quiesce tablespace
NULLIF - DB2 function
COALESCE - DB2 function
CASE expressions in SQL
Different ways for coding DCB parameter
Sort - limit the records
Sorting without JCL
Precompiler Option - STDSQL(NO/YES)
Defining SQL Communications Area in PL/I & COBOL
ONCODE: PL/I Built-In function
Indicator variables
DSNTIAR in PL/I
Handling SQL Error return codes - DSNTIAR
wanna know MVS version?
Easy way to search a member in multiple PDS
JOBLIB, STEPLIB, JCLLIB and PROCLIB
DFSORT FAQ _link
Can I reformat a record layout before/after sortin...
IEFBR16
GDG - Absolute Generation and Version Numbers
Can LOCK TABLE used on a view?
Abend B37
just an intro
About Me
Anu
This is a civil engineer plunged into Software.. Growing with IBM India since I boarded my professional life
View my complete profile
0 comments:
Post a Comment