Marin Komadina

Every DBA has a personal horror story about Oracle database corruption. A few DBAs, those that never taste this experience are missing the most challenging part of the DBA profession. Those mind-jarring calls in the middle of the night to come and repair a database problem only to discover upon arrival that the last good […]

Protecting and securing important information has always been a number one priority. Software companies try to build a product with as high an integrated level of security as possible that is still easy to handle and setup. IBM is no exception. With DB2,they provided an out-of-the-box database, wide-open for PUBLIC access, yet well equipped with […]

Archiving historical database data is an important, complex and in most cases forgotten task of database projects. Historical data has to be extracted and deleted from the database as a part of the archiving procedure. Extracted data is kept for several years as archived data, while the database retains only the actual, active set of […]

Performance is one of the most important factors for any kind of database system. Different companies and especially banks spend a fortune on high-performance hardware because it is still cheaper than efficient application code. This works until the system finally breaks down. DBAs have learned that performance of an application can be influenced by many […]

Project managers spend most of their working time producing reports, charts, graphs and calculations using the MS Excel spreadsheet program. Working with the spreadsheets, they are faced with several problems: My spreadsheets are spread all around network servers and local disks. How fast and how easy is it to find them? Is the data secured? […]

So, what exactly does a DBA need to know to be able to solve all his problems? Complexity of the modern relational database goes beyond the regular DBA’s knowledge. When looking at dozens of manuals, books and web pages, you may wonder, "Where else can I search?" A regular resource for questions about products, installation […]

A production DBA often faces the problem of a slow database caused by badly written SQL code. Even when tested by developers, SQL code can generate many performance problems. A regular pre-production test made on a manually generated, small dataset, when run on the real, big production dataset, can cause system breakdown. Some complex executions […]

A few years ago, many projects started using the multimedia capability of Oracle databases. Powerful procedures for handling image, audio, video and the text data in various formats are incorporated in the database kernel code; even the default database installation has multimedia objects installed. Storing, retrieving and searching the text from documents stored inside the […]

On the production Oracle system, a DBA is responsible for collecting database increase statistics. Collected information will be the basic triggers for purchasing additional storage resources. A DBA has several possibilities when it comes to the question of how to collect day-to-day database increase information. The minimal questions which need to be answered before starting […]

The DBAs Delima In today’s market, deciding which utility to use can be a major decision for the DBA. Some questions that I hear quite frequently are: "Could you please, share some experience with third party query analysis tools for DB2?" "What is the best, IBM or third party tools for DB2 database administration" "I […]

From time to time, DBAs have to take over "alien" databases. These databases are usually living parts from some failed project, a badly documented job from a previous DBA or in a worst case scenario, a database with very important data without any support. The situation gets worse when the database has the Java Option […]

Beside the standard Command Line Processor Commands (CLP), DB2 is enhanced with full set of system commands. DB2 system commands are used to access and maintain the DB2 database and can be entered from the OS command line, or can be used in a shell script. Set of commands depends on the version and packaging […]