ChannelDB2

DB2 IN INDIA Discussions (86)

← Back to DB2 IN INDIA
Discussions Replies Latest Activity

DB2 Tips n Tricks Part 87 - How To Map Table File Object Id with Table Name in SMS Table Space

Hi All, How To Map Table File Object Id with Table Name in SMS Table Space Use: TABLEID Column in SYSCAT.TABLES TAB_FILE_ID Column in MON…

Started by Harishkumar Baburao Pathangay

0 Apr 8

DB2 Tips n Tricks Part 86 - How To Export Table Data to Tab Delimited File

Hi All,   How To Export Table Data to Tab Delimited File Use Export Command with File Type Modifier COLDEL   DB2 EXPORT   Thanks, H…

Started by Harishkumar Baburao Pathangay

0 Mar 25

DB2 Tips n Tricks Part 85 - How Archive Log Start End Time in List History Output is counter intuitive

Hi All,   How Archive Log Start End Time in List History Output is counter intuitive How To Find How Long a Transaction Log File is in Ac…

Started by Harishkumar Baburao Pathangay

0 Mar 18

DB2 Tips n Tricks Part 84 - How DB2 is not logging Start Time for Archival of Transaction Log Files

Hi All,   How DB2 is not logging Start Time for Archival of Transaction Log Files DB2 Archival Logging   Thanks, Happy Learning & S…

Started by Harishkumar Baburao Pathangay

0 Mar 13

DB2 Tips n Tricks Part 83 - How MON_GET_DATABASE Routine reports incorrect db activation state

Hi All,   How MON_GET_DATABASE Routine reports incorrect db activation state Solution: Watch DB2 Tips n Tricks Part 40   DB2 DB_ACTIVAT…

Started by Harishkumar Baburao Pathangay

0 Mar 3

DB2 Tips n Tricks Part 82 - How To Find Recent Reorganization date-time of a Table

Hi All,   How To Find Recent Reorganization date-time of a Table Solution: Use List History Reorg All For dbname Use SYSIBMADM.DB_HISTO…

Started by Harishkumar Baburao Pathangay

0 Feb 24

DB2 Tips n Tricks Part 81 - How To Flush Static Packages from Package Cache Memory

Hi All,   How To Flush Static Packages from Package Cache Memory Solution: Use SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS Stored Procedure   D…

Started by Harishkumar Baburao Pathangay

0 Feb 15

DB2 Tips n Tricks Part 80 - How DB2PD reports incorrect dirty pages in buffer pool

Hi All,   How DB2PD reports incorrect dirty pages in buffer pool Solution: Use db2pd -db dbname -dirtypages summary   DB2PD Dirty Pages…

Started by Harishkumar Baburao Pathangay

0 Jan 30

DB2 Transactional perfromance Question.

I have a table A with 30,000 Records. Module B  selects the data from the table A. This  module B is  called  via online(CICS) and Batch mo…

Started by Satya

0 Jan 18

DB2 Tips n Tricks Part 79 - How To Find Application Execution or Idle Time

Hi All, How To Find Application Execution or Idle Time Solution: Use Routine MON_GET_AGENT DB2 Agent State Time Thanks, Happy Learnin…

Started by Harishkumar Baburao Pathangay

0 Jan 6

RSS

Try BLU Acceleration on Cloud

© 2016   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service