Home
Videos uploaded by user “DB2-LUW-ACADEMY”
DB2 Tips n Tricks Part 30 - How to Find Which DB2 Thread is consuming High CPU
 
12:47
How to Find Which DB2 Thread is consuming High CPU Solution: db2pd -edus Top -Hp db2syscpid Ps -Lp db2syscpid -o pid,ppid,pcpu,pmem,lwp Happy Learning & Sharing
Views: 13907 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 31 - Find Which Application is consuming most log space
 
05:54
How to Find Which Application is consuming most transaction log space Solution: db2pd -db dbname -transactions db2 get snapshot for applications on test|grep -i -e "Application handle" -e "UOW log space used"
Views: 6691 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 35 - How to Access Remote DB2 Database from Client Machine
 
10:11
How to Access Remote DB2 Database from Client Machine Solution: Install DB2 Run Time Client Software in Client Machine Catalog Node and Catalog Database on Remote Node Attach to Instance or Connect to Database Happy Learning & Sharing
Views: 9905 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 25 - How to Find unused tables,indexes or stored procedures in the Database
 
06:10
How to Find unused tables,indexes or stored procedures in the Database. When it was last accessed? Solution: LASTUSED Column in SYSCAT.TABLES,SYSCAT.INDEXES,SYSCAT.PACKAGES Happy Learning & Sharing
Views: 3740 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 23 - How to Find Application consuming most System Temp Table Space
 
08:42
How to Find Which Application is consuming most System Temp Table Space Solution: db2pd -db dbname -tcbstats tmp_space_id Happy Learning & Sharing
Views: 3778 DB2-LUW-ACADEMY
DB2-Tips n Tricks - Part 1 - History, Time taken, Performance for RUNSTATS
 
11:44
History for RUNSTATS Time taken for RUNSTATS of each Table Performance for RUNSTATS
Views: 10293 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 58 - How To Find Indexes used by Query without getting Explain Plan
 
05:50
How To Find Indexes used by Query without getting Explain Plan Solution: Use MON_GET_SECTION_OBJECT Routine No Need of Explain Tables and Format Explain Output Happy Learning & Sharing
Views: 2845 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 56 - How to Force Query to use IXSCAN over a TBSCAN
 
13:48
How to Force Query to use IXSCAN over a TBSCAN Solution: Define Optimization Profile with guidelines accordingly. Happy Learning & Sharing
Views: 3134 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 55 - How Table Size increased after Table Reorganization
 
08:43
How Table Size increased after Table Reorganization Solution: Check for PCTFREE Table Attribute; If set to 50 then after table reorganization it will double the table size. Also, When loading 10GB if Data, it will occupy 20GB of Table Size. Happy Learning & Sharing
Views: 1680 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 13 - How to find Application Level Sort Memory Consumption
 
07:21
HOW TO FIND WHICH APPLICATION CONSUMES HIGH SORT MEMORY? Application Snapshot provides only no: of sorts and not sort memory consumed. DB Snapshot provides sort memory but in total at DB level. Solution : db2pd -db dbname -sort Happy Learning & Enjoy
Views: 1923 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 49 - How to Find Size,Invalid Indexes and Rebuild Manually
 
04:22
How to Find Size,Invalid Indexes and Rebuild them Manually Solution: Use Routine SYSPROC.ADMIN_GET_INDEX_INFO() REORG INDEXES ALL FOR TABLE STAFF ALLOW READ ACCESS REBUILD Happy Learning & Sharing
Views: 1913 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 37 - How To Load Compressed Files directly without Extracting to Harddisk
 
08:22
How To Load Compressed Files directly without Extracting to Harddisk Solution: Create a Named Pipe File in Unix - mkfifo data.del Unzip -p Compressed File to Named Pipe File Unzip Process does not extract to Hard Disk Import / Load from Named Pipe of del insert into table name Happy Learning & Sharing
Views: 1881 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 4 - Move/Copy Data without Intermediate Data Files
 
20:43
DB2 Tips n Tricks Video Part 4 uploaded. How to move/copy Data without Intermediate Data(DEL/IXF) Files. Method 1 : Load With Cursor Called as Remote Load Method 2 : DB2MOVE Utility with COPY Action Demonstrated with Examples. Happy Learning and Enjoy!!!! Thanks, DB2-LUW-ACADEMY
Views: 5996 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 73  - How to Find if STMM is Active or Idle
 
05:40
How to Find if STMM is Active or Idle Solution: db2 get db cfg show detail SYSIBMADM.DBCFG Instance_Home/sqllib/db2dump/stmmlog/stmm.n.log Happy Learning & Sharing
Views: 924 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 59 - How To Find various Paths used by Database
 
04:43
How To Find various Paths used by Database Solution: Use Admin View SYSIBMADM.DBPATHS. SYSIBMADM.DBCFG Happy Learning & Sharing
Views: 605 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 78 - How Classic Offline Reorganization consumes more Transactional Log Space
 
04:48
How Classic Offline Reorganization consumes more Transactional Log Space Solution: Provide Additional Transactional Log Space for Classic Clustered Reorganization of Table Happy Learning & Sharing
Views: 853 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 66  - Regular Restore of 32 BIT DB into 64 BIT Instance not possible
 
16:06
How Regular Restore of 32 BIT DB into 64 BIT Instance is not possible Solution: Use Redirected Restore or specify ON Clause during Restore Happy Learning & Sharing
Views: 1101 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 32 - How to Configure Port Number for DB2 Instance
 
06:17
How to Configure Port Number for DB2 Instance Solution: db2set DB2COMM=TCPIP db2 update dbm cfg using svcename db2inst2 Edit the /etc/services file to contain port number entries Restart Instance Happy Learning & Sharing
Views: 3302 DB2-LUW-ACADEMY
DB2 Tips n Tricks - Part 3 - SET INTEGRITY for Re-Generation of Generated Columns
 
07:51
DB2 Tips n Tricks Video Part 3 uploaded. No Need to Drop and Re-create Generated Columns for altering them. Use SET INTEGRITY for RE-GENERATION OF GENERATED COLUMNS as explained with online example.....
Views: 3018 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 82 - How To Find Recent Reorganization date-time of a Table
 
02:44
How To Find Recent Reorganization date-time of a Table Solution: Use List History Reorg All For dbname Use SYSIBMADM.DB_HISTORY Happy Learning & Sharing
Views: 1358 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 47 - How Force Applications All will shutdown Database
 
04:32
How Force Applications All will shutdown Database Solution: Explicitly Activate Database db2 activate db dbanme Happy Learning & Sharing
Views: 909 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 24 - How to Find Application consuming most Statistics or Statement Heap
 
07:15
How to Find Application consuming most Statistics or Statement Heap Solution: db2mtrk -a -v MON_GET_MEMORY_POOL('memory type','db name',member) Happy Learning & Sharing
Views: 1929 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 14 - How to Relocate DB using DB2RELOCATEDB Utility
 
28:45
DB2RELOCATEDB Utility - Simple yet powerful utility for relocation of entire or portion of database. Scenarios: * Copy or Move an entire db from source instance to target instance * Modify storage / container paths of an existing database Happy Learning & Enjoy
Views: 3340 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 71  - How To Change Fenced User Id after Instance Creation
 
05:05
How To Change Fenced User Id after Instance Creation Solution: db2iupdt -u fenceduserid instname Happy Learning & Sharing
Views: 993 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 86 - How To Export Table Data to Tab Delimited File
 
03:49
How To Export Table Data to Tab Delimited File Use Export Command with File Type Modifier COLDEL Happy Learning & Sharing
Views: 1802 DB2-LUW-ACADEMY
DB2 Tutorial Introduction
 
01:12:23
This is a introductory tutorial. Look out for more videos periodically. Agenda: System/Instance/Database Instance/DB Comfiguration and Directory Creation of Database - Storage Path and Database Path I also offer DB2 tutorial online/in person. Contact me at [email protected]
Views: 99770 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 121 - Difference Between MAX_LOG vs NUM_LOG_SPAN
 
16:29
Difference Between MAX_LOG vs NUM_LOG_SPAN Happy Learning & Sharing http://db2luwacademy.blogspot.in
Views: 428 DB2-LUW-ACADEMY
DB2 Tips n Tricks - Part 5 - Table Level Monitoring by MON_GET_TABLE() Function
 
19:50
Demonstrate Table Level Monitoring using MON_GET_TABLE() Function. Monitoring Table Activities : Tables with most Number of Rows Read,Inserted,Updated,Deleted Categorize Read or Write Intensive Tables Number of Table scans indicating Need for Indexes Number of Rows Read per Table Scan Hit Ratio - Physical Reads / Logical Reads at a Table level useful for Bufferpool Tuning Lock Wait Time / Number of Lock Waits - Calculate Average Time an Application waits for acquiring a lock on a table. and Much More......Demonstrated with Examples. Happy Learning and Enjoy!!!! Thanks, DB2-LUW-ACADEMY
Views: 5510 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 65  - How Load Utility uses Huge Transaction Log Space
 
13:16
How Load Utility consumes Huge Transactional Log Space Solution: LOAD using valid Data Sets without redundant records Increase LOG SECOND DB CFG parameter IMPORT / INGEST with COMMIT COUNT Happy Learning & Sharing
Views: 2642 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 63  - How To Install DB2 using Response File
 
12:47
How To Install DB2 using Response File or Silent Installation Solution: db2setup -r response file Happy Learning & Sharing
Views: 1290 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 100 - How To Save Space in Archive Log File System
 
04:40
How To Save Space in Archive Log File System Enable Archival Log Compression Happy Learning & Sharing
Views: 727 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 90 - How Classic Table Reorganization using Temp Tablespace cannot be stopped
 
06:04
How Classic Table Reorganization using Temporary Tablespace cannot be stopped.
Views: 713 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 101 - How To Start/Stop DB2 Instance without using DB2START
 
08:05
How To Start/Stop DB2 Instance without using DB2START Configure Autostart Instance or Configure Fault Monitor Happy Learning & Sharing
Views: 1854 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 21 - How to Override Current Committed Semantics for a specific select query
 
12:29
How to Override Current Committed Semantics for a specific select query Override Registry Variables:DB2_SKIPINSERTED, DB2_SKIPDELETED, DB2_EVALUNCOMMITTED Solution: WAIT FOR OUTCOME Clause Happy Learning & Sharing
Views: 1183 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 50 - How to Monitor Index Reorganization
 
08:07
How to Monitor Index Reorganization Solution: db2pd -db dbname -reorg index Happy Learning & Sharing
Views: 2951 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 2 - SYSIBMADM.ADMINTABINFO
 
12:17
DB2 Tips n Tricks Video Part 2: SYSIBMADM.ADMINTABINFO for finding physical sizes of table,compression dictionary size and re-org recommended alter operations and a lot more....
Views: 5166 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 91 - How To Add or Drop Containers from SMS Temporary Tablespaces
 
05:42
Description: How To Add or Drop Containers from SMS Temporary Tablespaces without Redirected Restore. Happy Learning & Sharing
Views: 781 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 33 - How to set Client Application Name for Client Connection
 
09:43
How to set custom,user friendly Client Application Name for Client Connection Solution: set Client Application Name Property of Connection Object DataSource.setClientProgramName("string") ClientApplName property in db2cli.ini Configuration file Happy Learning & Sharing
Views: 1943 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 7 - Security Routines for Authorities, Admin Views for Privileges
 
28:19
Security Routines for Authorities: VALUES SYSPROC.AUTH_GET_INSTANCE_AUTHID() - Get Instance Owner SYSPROC.AUTH_LIST_AUTHORITIES_FOR_AUTHID() - List Authorities for User/Group/Roles SYSPROC.AUTH_LIST_ROLES_FOR_AUTHID() - List Roles for User/Group/Roles SYSPROC.AUTH_LIST_GROUPS_FOR_AUTHID() - List Group Association for User Admin Views for Privileges and Object ownerships: SYSIBMADM.AUTHORIZATIONIDS - List of Users/Groups/Roles having access to the Database SYSIBMADM.PRIVILEGES - Detailed Information on Privileges held by Users on Database Objects SYSIBMADM.OBJECTOWNERS - Detailed Information on Ownership of Database Objects --- Thanks & Happy Learning
Views: 2775 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 34 - Remotely Start Stop DB2 Instance from Client Machine
 
06:47
How to Remotely Start Stop DB2 Instance from Client Machine Solution: db2 stop dbm remote bjp hostname 192.168.137.1 user harish using pwd db2 start dbm remote bjp hostname 192.168.137.1 user harish using pwd Happy Learning & Sharing
Views: 1973 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 48 - How to Connect to Database in Single User Only Mode
 
04:50
How to Connect to Database in Single User Only Mode Solution: db2 connect to dbname in exclusive mode user/using Happy Learning & Sharing
Views: 1168 DB2-LUW-ACADEMY
DB2 HADR Part 3 - Tips on Backup of HADR Databases
 
14:05
Online / Offline Backup of HADR Stand by database is not possible excluding Snapshot Backups. Online / Offline Backup of HADR Primary database is possible even if Standby is not reachable. Happy Learning & Sharing http://db2luwacademy.blogspot.in
Views: 998 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 51 - How To List all Database Objects in a Schema
 
06:32
How To List all Database Objects in a Schema Solution: Use SYSIBMADM.OBJECTOWNERS Admin View or db2look -d dbname -e -z schema-name Happy Learning & Sharing
Views: 3307 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 92 - How LOB Values are not logged for Non Recoverable Databases
 
05:10
How LOB Values are not logged for Non Recoverable Databases Configure to Recoverable Database for logging LOB Values into Transactional Log Files Happy Learning & Sharing
Views: 359 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 20 - How to Avoid Transaction Rollback after Lock Timeout
 
12:18
How to Avoid Transaction Rollback after Lock Timeout db2set DB2LOCK_TO_RB = STATEMENT Happy Learning & Sharing
Views: 2361 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 10 - Find Paths used by Database from Backup image
 
06:25
How to Find Storage and Table space Paths used by Database from Backup image only. Use Backup Verification Tool; db2ckbkp -S [image] or db2ckbkp -T [image]. Options -s, -t gives path info along with verifying the image. Happy Learning & Enjoy
Views: 1835 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 22 - How to Exclusively lock set of Rows using select query
 
08:56
How to Exclusively lock a set of Rows using select query Solution: LOCK REQUEST Clause USE and KEEP SHARE/UPDATE/EXCLUSIVE Locks Happy Learning & Sharing
Views: 2047 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 15 - How to Configure LDAP Plugin for Authentication and Group Look-Up
 
25:21
How to Configure LDAP Security Plugin for Authentication and Group Look-Up using built-in sample plugins * IBMLDAPauthserver - userid,password plugin for authentication * IBMLDAPgroups - Group-Lookup plugin Happy Learning & Enjoy
Views: 2563 DB2-LUW-ACADEMY
DB2 Performance Myth Buster 1 - How Bufferpool with 100% Hit Ratio still has Performance Bottleneck
 
18:50
How Bufferpool with 100% Hit Ratio still has Performance Bottleneck Look for Page Cleaning. Happy Learning & Sharing
Views: 1448 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 72  - How db2 get instance displays incorrect instance
 
04:51
How db2 get instance displays incorrect instance How to Switch between multiple instances Solution: Execute /home/db2inst1/sqllib/db2profile for switching instances Issue db2 terminate when switching between multiple instances Happy Learning & Sharing
Views: 795 DB2-LUW-ACADEMY

Here!
Here!
Here!
Here!
Online dating sites dangers of electronic cigarettes