What I'm Thinking

Explanation on DB2 Explain
19 January 2012

When an SQL is executed against or bound to a DB2 database, DB2 Optimizer tool defines the access path used to access the data. This access path is defined according to tables’ statistics generated by DB2 Runstats tool. The Explain command details the access path defined by DB2 and allows you to analyze how the data will be accessed and how you can improve the command’s performance. A table called PLAN_TABLE which has your user id as its owner is required for working on DB2 Explain. ... Read More

Appending to ISPF Clipboard
19 January 2012

Scenario: I have a dataset with 10,000 lines. I want to cut the first 10 lines and last 10 lines and paste into another dataset. When I cut the first 10 lines and then again the last 10 lines, only the last 10 lines are pasted into the new dataset. Is there anyway out (other than doing a 2 cut & paste)? Yes, here it is. First cut 10 lines, then issue CUT APPEND. ... Read More
When I issue CUT , I know that the CUT content are placed in a clipboard. And when I issue PASTE, the clipboard content are pasted. But is it possible for me to view and edit the clipboard? One can view the clipboard after any valid CUT command was issued. To view the clipboard, issue : CUT DISPLAY Clipboard manager will pop up and gives us options to edit or browse the content. ... Read More
Usually the PDS or PS bears the ID of the creator or the ID of the person who modified it recently. It’s possible to change these ID values without leaving trace of one’s own ID. In the command area against the member name or PS name, by giving ‘G’. Dialog box will pop up allowing you to change the ID values.
Any command entered in the ISPF COMMAND LINE disappears after the successful execution of its intended function. If you want to repeat the same command , you got to re-type it or use some PF key to retrieve the last command entered. But here is a cool method the make the command entered not to disappear and stay on the screen. Precede commands with “&“. For Example: &C ‘110-PARA’ ‘220-PARA’ ... Read More