Published on March 12, 2014
Top 10 DB2 SupportTop 10 DB2 SupportTop 10 DB2 SupportTop 10 DB2 Support Nightmares & How toNightmares & How toNightmares & How toNightmares & How to Avoid ThemAvoid ThemAvoid ThemAvoid Them #1#1#1#1
Part 1 - Unintended Consequences A Junior DBA connects to the wrong system to clear down a table Image of a junior DBA
Data column 1 Data column 2 Data column 3 5645681356 ERTRGFD455 3985223 3526412541 GOGTNBSZ88 3212587 5498741355 YKMHNBIH91 6887119 8789781155 KOVUSDHA24 5645410 2125541101 KTJTKHJKIH91 9832546 4658786412 PKJDSHAGB58 2121005 6587441147 FNGJHGFUG93 9741248 All the rows in a critical table in a pre- production environment are deleted!
The Technical Bit • The Junior DBA connected to the wrong system by mistake, using instance owner userid • The System Administrator had been trying to get federation to work, and in addition to enabling the FEDERATED database manager parameter, the FED_NOAUTH (bypass federated authentication) parameter had also been set to YES. • When FED_NOAUTH is set to YES, FEDERATED is set to YES, and authentication is set to SERVER or SERVER_ENCRYPT, then authentication at the instance is bypassed, as it is assumed that authentication will happen at the data source. • So, it was possible to connect to the database as any user without having to get the password right! Once connected to the database, you only had access to the tables that the user (group) had access to. However, this meant if anyone got the right username for the DB2 instance owner then they could select/add/delete any data they liked!
The Moral of the Story Never underestimate the law of Unintended Consequences! What you’re doing in one part of the database may have far reaching effects. DB2 can be a complex beast! A little knowledge is dangerous. Fiddling with settings can cause all sorts of problems. Don’t underestimate the need for a skilled DB2 support.
Slide 6 U1 Make this image a full page with the triton logo and contact details User, 24/02/2014
you our top 10 and give you some advice on how to avoid such situations ... so DB2 support was not ... Top 10 DB2 Support Nightmares & How to Avoid ...
Number 8 in our Top 10 DB2 Support Nightmares series. ... DB2 10.1; DB2 10.5; DB2 11; DB2 11; DB2 8; DB2 9; DB2 9.5; DB2 9.7; DB2 9.8; DB2 Administration ...
Number 8 in our Top 10 DB2 Support Nightmares series. ... Posted in DB2, DB2 Support | Tagged DB2, DB2 consultancy, db2 support | 1 Comment.
... features in DB2 10 that should be at the top of ... Top 10 Tips about Learning DB2 10.1 for LUW. ... strong enough to support my ...
Here are 10 DB2 disasters ... Top 10 DB2 Support Issues. ... Here's a nightmare support scenario: ...
... specialising in DB2 support and IBM DB2 ... to receive all cookies on the Triton Consulting ... Top 10 DB2 Support Nightmares and how to ...