ChannelDB2

DB2 in Brazil Discussions (97)

← Back to DB2 in Brazil
Discussions Replies Latest Activity

DB2 Tips n Tricks Part 48 - How to Connect to Database in Single User Only Mode

Hi All, How to Connect to Database in Single User Only Mode Solution: db2 connect to dbname in exclusive mode user/using DB2 Exclusive Co…

Started by Harishkumar Baburao Pathangay

0 Oct 25, 2014

How Force Applications All will shutdown Database

Hi All, How Force Applications All will shutdown Database. Solution: Explicitly Activate Database db2 activate db dbanme DB2 Explicit DB…

Started by Harishkumar Baburao Pathangay

0 Oct 23, 2014

DB2 Tips n Tricks Part 46 - How to Find Fenced User ID for an Instance

Hi All,Video Tutorial-How to Find Fenced User ID for an InstanceSolution:User ID running the db2fmp Process is Fenced Userps -eaf|grep -i -…

Started by Harishkumar Baburao Pathangay

0 Oct 14, 2014

DB2 Tips n Tricks Part 45 - How To Find JAVA Driver Name and Version

Hi All,How to Find JAVA Driver Name and VersionSolution:For JDBC com.ibm.db2.jcc.DB2Jcc -versionFor SQLJ sqlj.tools.Sqlj -versionDB2 Java D…

Started by Harishkumar Baburao Pathangay

0 Oct 6, 2014

Force User re-prepare query at UOW boundary

Hi All,How to Force User to re-prepare query after execution beyond transactional boundarySolution:Use Pre-Compile Option - KEEPDYNAMIC NOD…

Started by Harishkumar Baburao Pathangay

0 Oct 4, 2014

How the CURRENT_USER special register is not always displyaing current user

Hi All, How the CURRENT_USER special register is not always displyaing current user.Solution:Use SESSION_USER OR USER special register to d…

Started by Harishkumar Baburao Pathangay

0 Sep 27, 2014

DB2 PureScale

Pessoal, bom dia! Estou em busca de material/labs/cursos ou o que for, para DB2 PureScale (instalação, configuração, monitoração, etc), po…

Started by Gabriel Luchina

8 Sep 17, 2014
Reply by DANIEL LUIS HENRIQUES SKEFF

How to Identify or Monitor DB2 Client Release Version from Server side

Hi All,Video Tutorial-How to Identify or Monitor DB2 Client Release Version from Server sideSolution:CLIENT_PRDID - Client Product ID Monit…

Started by Harishkumar Baburao Pathangay

0 Aug 21, 2014

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

RSS

Try BLU Acceleration on Cloud

© 2015   Created by channeldb2.

Badges  |  Report an Issue  |  Terms of Service