by XTIVIA | Oct 28, 2015 | Blog, Data Management, Databases
To run any SQL or perform runstats or other actions, you must establish a connection to a DB2 database. Connecting to a Database Connecting to an existing database on the same database server the database exists on, or connecting to an already cataloged database is...
by XTIVIA | Oct 22, 2015 | Blog, Data Management, Databases
In order to connect to a DB2 database that is not on the server or workstation you’re connecting from, you’ll need to make DB2 aware of that database by cataloging it, unless you’re using JDBC type 4 drivers. JDBC type 4 drivers do not require that a...
by XTIVIA | Oct 14, 2015 | Blog, Data Management, Databases
Keeping track of SQL Server Jobs is an important part of maintaining a database proactively. The below script pulls a quick list of all jobs, completion status, and date the job ran. Taking this a step further one could have the SQL Server email them a copy...
by XTIVIA | Oct 13, 2015 | Blog, Data Management, Databases
What can you do to attract and retain skilled and constantly evolving DB2 DBAs? In my 14 years working with DB2 at a number of companies, I have seen a number of different environments, and the ones that keep talented folk happy provide these things: Technical Breadth...
by XTIVIA | Oct 6, 2015 | Blog, Data Management, Databases
Data Corruption is something that no one really wants. Yet every now and then, we see some customers run into this. Any such issues are almost always the result of disk or SAN level issues. You will see errors like this: SQL1655C The operation could not be completed...
by XTIVIA | Sep 17, 2015 | Blog, Data Management, Databases
Shortly after creating a database on your server you should be planning and scheduling your backup. Easy as it sounds it’s often approached incorrectly. Often the decision when to backup is based on when the server resource usage is low. Database Backup maintenance...
