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: 13356 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: 6386 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: 10000 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: 9386 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: 3650 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: 3667 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: 5721 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: 3024 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: 2700 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: 3247 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: 5063 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: 1893 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 96 - How To Run very Huge Transaction with less Active Log Space File System
 
08:57
How To Run very Huge Transaction with less Active Log Space File System configure Infinite Logging Happy Learning & Sharing
Views: 852 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: 1759 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: 1877 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: 5314 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: 1634 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: 897 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: 2947 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 union SYSIBMADM.DBCFG Happy Learning & Sharing
Views: 688 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 9 - Obviate a Drop Table Scenario
 
06:40
Prevent Accidental Drop of a Table. Solution : Use "Restrict on Drop" Clause in Create / Alter Table Statement; Pre-emptive Approach with no Performance Overhead. Drop table Recovery is only a contingency plan. Happy Learning & Enjoy
Views: 1546 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: 3166 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: 1319 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: 1837 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: 1887 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 29 - How to Persist Locks even after transaction commits
 
09:25
How to Persist Locks even after transaction commits Solution: db2set DB2_KEEPTABLELOCK=CONNECTION Happy Learning & Sharing
Views: 1473 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: 2526 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: 3183 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: 99013 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 38 - Limitation on Monitor Metrics by Dynamic SQL Snapshot
 
12:15
How Dynamic SQL Snapshot is Technically Correct but Functionally Incorrect Solution: Dynamic SQL Snapshot aggregates monitor metrics based on Statement Text. Use MON_GET_PKG_CACHE_STMT aggregates monitor metrics based on Execution Id. Happy Learning & Sharing
Views: 1547 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 79 - How To Find Application Execution or Idle Time
 
06:26
How To Find Application Execution or Idle Time Solution: Use Routine MON_GET_AGENT Routine Happy Learning & Sharing
Views: 922 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: 592 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 85 - How Archive Log Start End Time in List History is counter intuitive
 
07:07
How Archive Log Start End Time in List History Output is counter intuitive How To Find How Long a Transaction Log File is in Active Log Directory before getting Archived Use List History Archive Log All for db dbname Happy Learning & Sharing
Views: 1014 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: 2477 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: 1652 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: 2676 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 88 - How To Find if a Change in Registry Variable is Effective Immediately
 
04:00
How To Find if a Change in DB2 Registry Variable is Effective Immediately Use: db2set -info variablename Happy Learning & Sharing
Views: 578 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 46 - How to Find Fenced User ID for an Instance
 
04:57
How to Find Fenced User ID for an Instance Solution: User ID running the db2fmp Process is Fenced User ps -eaf|grep -i -e db2fmp -e db2sysc cat DB2HOME/sqllib/ctrl/.fencedID Happy Learning & Sharing
Views: 1068 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: 1150 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: 700 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 67  - How to change from BACKUP PENDING to NORMAL State asap
 
07:45
How to change from BACKUP PENDING to NORMAL State asap Solution: Use Backup dbname online to /dev/null Happy Learning & Sharing
Views: 1720 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: 1957 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 8 - Restore an accidentally dropped table space
 
28:52
Accidentally Dropped Incorrect Table space. Not to worry. Solution 1: Restore entire db and roll forward to point in time just before drop table space - Time,Resource Inefficient - Bad Choice Solution 2: Rebuild a new DB with SYSCATSPACE ,Dropped Table space and roll forward it to point in time just before drop table space - Time,Resource Efficient - Good Choice Happy Learning & Sharing
Views: 7389 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: 781 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 39 - Deploy Stored Procedure without revealing source code
 
08:38
How to Deploy Stored Procedure without revealing source code Solution: Generate a Stored Procedure Archive File using GET ROUTINE command. Deploy the routine using PUT ROUTINE command. Happy Learning & Sharing
Views: 1679 DB2-LUW-ACADEMY
DB2 Tips n Tricks Part 60 - How To Export Import Catalog Entries from one Instance to Another
 
10:42
How To Export Import Catalog Entries from one Instance to Another Solution: Use DB2CFEXP for Export and DB2CFIMP for Import of DB2 Directory,Registry Variables values. Happy Learning & Sharing
Views: 2449 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: 790 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: 755 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: 356 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: 1259 DB2-LUW-ACADEMY

Syndroom van reye aspirin 81mg
Megastat 40 mg lisinopril
V1mcg definition of socialism
Paroxetine hcl 10mg and alcohol
Synulox gdzie kupic