ChannelDB2

DB2 for Linux, UNIX, Windows Discussions (104)

← Back to DB2 for Linux, UNIX, Windows
Discussions Replies Latest Activity

Video Tutorial-How to get Admin Authorities on a Restored Database

Hi All,Video Tutorial-How to get Admin Authorities on a Restored Database.Solution:db2set DB2_RESTORE_GRANT_ADMIN_AUTHORITIES=ONRestart Ins…

Started by Harishkumar Baburao Pathangay

0 Aug 16, 2014

How to Find if a Database was implicitly or explicitly activated or deactivated

Hi All,Video Tutorial-How to Find if a Database was implicitly or explicitly activated or deactivated.Solution:db2diag.log file has distinc…

Started by Harishkumar Baburao Pathangay

0 Aug 3, 2014

Video Tutorial - How to Deploy Stored Procedure without revealing source code

Hi All,Video Tutorial - How to Deploy Stored Procedure without revealing source code. Solution:Generate a Stored Procedure Archive File usi…

Started by Harishkumar Baburao Pathangay

0 Jul 21, 2014

Video Tutorial-How Dynamic SQL Snapshot is Technically Correct but Functionally Incorrect

Hi All, Video Tutorial-How Dynamic SQL Snapshot is Technically Correct but Functionally Incorrect- Use MON_GET_PKG_CACHE_STMT instead. Sol…

Started by Harishkumar Baburao Pathangay

0 Jul 13, 2014

Video Tutorial-How To Load Compressed Files directly without Extracting to Harddisk

Hi All,Video Tutorial-How To Load Compressed Files directly without Extracting to Harddisk.Solution:Create a Named Pipe File in Unix - mkfi…

Started by Harishkumar Baburao Pathangay

0 Jul 7, 2014

Video Tutorial-How to Find Empty/Blank Log files in Active Log Space

Hi All,Video Tutorial-How to Find Empty/Blank Log files in Active Log Space.Solution:db2flsn -db test -lsnrangedb2flsn -db test -lsnrange l…

Started by Harishkumar Baburao Pathangay

0 Jun 28, 2014

Video Tutorial-How to Access Remote DB2 Database from Client Machine.

Hi All, Video Tutorial-How to Access Remote DB2 Database from Client Machine.Solution:Install DB2 Run Time Client Software in Client Machin…

Started by Harishkumar Baburao Pathangay

0 Jun 26, 2014

How to Remotely Start Stop DB2 Instance from Client Machine

Hi All, Video Tutorial-How to Remotely Start Stop DB2 Instance from Client Machine.Solution:db2 stop dbm remote bjp hostname 192.168.137.1…

Started by Harishkumar Baburao Pathangay

0 Jun 13, 2014

How to set custom,user friendly Client Application Name for Client Connection

Hi All, Video Tutorial-How to set custom,user friendly Client Application Name for Client Connection.Solution:set Client Application Name P…

Started by Harishkumar Baburao Pathangay

0 Jun 8, 2014

Video Tutorial-How to Configure Port Number for DB2 Instance

Hi All, Video Tutorial-How to Configure Port Number for DB2 Instance.Solution:db2set DB2COMM=TCPIPdb2 update dbm cfg using svcename db2inst…

Started by Harishkumar Baburao Pathangay

0 May 20, 2014

RSS

Try BLU Acceleration on Cloud

© 2015   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service