Top 10 DB2 support nightmares #1

50 %
50 %
Information about Top 10 DB2 support nightmares #1

Published on March 12, 2014

Author: LauraHood



Join us (if you dare!) as the DB2 Geek takes us on a tour of his Top 10 DB2 Support Nightmares.

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

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Top 10 DB2 Support Nightmares & How to Avoid Them

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 ...
Read more

Top 10 DB2 Support Nightmares and How to Avoid Them #8 ...

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 ...
Read more

Db2 Support | Triton Consulting

Number 8 in our Top 10 DB2 Support Nightmares series. ... Posted in DB2, DB2 Support | Tagged DB2, DB2 consultancy, db2 support | 1 Comment.
Read more

Top 10 Tips about Learning DB2 10.1 for LUW ...

... 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 ...
Read more

Top 10 DB2 Support Issues —

Here are 10 DB2 disasters ... Top 10 DB2 Support Issues. ... Here's a nightmare support scenario: ...
Read more

Triton Consulting - DB2 Consultants providing consultancy ...

... specialising in DB2 support and IBM DB2 ... to receive all cookies on the Triton Consulting ... Top 10 DB2 Support Nightmares and how to ...
Read more