Db2 Experts on a Data Science Quest
SQL0803N is an error message that means the SQL statement just issued failed due to violating a unique constraint within the database. The ‘N’ at the end of this error means that this statement failed and was not executed, but that it is probably not a database system issue.… Read the rest
Continue reading »
When I do work in other domains – even something as connected as scripting – I find the error messages confusing and unhelpful. Most of the time, this is mostly because I don’t know much about the language or the the area.… Read the rest
Continue reading »
I ran into this error message recently and thought I’d describe what the issue was.
I was building a new consolidated development database server for a client – moving away from 10 separate database servers to one (big) VM to run their development workloads.… Read the rest
Continue reading »
I’d like to think that I’m pretty decent at backup and recovery. I’ve done hundreds of restores in my career in a vast array of scenarios for real-world recovery, data movement, and fixing developers’ mistakes. Today I saw an error I’ve never seen before, so I thought I’d share.… Read the rest
Continue reading »
I can’t say that I work with federation on a daily basis. I have, however, set up federation for an Oracle data source from top to bottom, and support at least one system on a daily basis that uses federation to access Oracle, Informix, and DB2 for AS/400.… Read the rest
Continue reading »
Loading data into a DB2 database using the LOAD utility has a lot of ins and outs. If a DBA has spent a lot of time working in a database without referential integrity or check constraints, then they may forget to check for tables in a check-pending state after loading data.… Read the rest
Continue reading »I recently ran into a couple of db2look problems for different clients, and thought I’d share them in case someone else runs into them.
db2look is a tool used to mimic databases, objects, or statistics. If you are not familiar with it, check out my post on DB2 Basics: db2look.… Read the rest
Continue reading »When connecting between different versions of DB2, you generally need to bind packages from the different versions against the DB2 database. Just because you’ve bound db2ubind and db2cli on the server does not mean that all possible clients connecting in are covered.… Read the rest
Continue reading »This is a topic I have to look up from time to time, and I always go straight to Serge Rielau’s blog. He has a number of good articles on LISTAGG, the similar XML specific functions, and much more.
While he’s already covered the topic in great detail, I thought I’d add my own way of looking at it, and a use case or two for DB2 System views.… Read the rest
Continue reading »Backups are so ingrained into DBAs. They should really be the first and the last thing we think of and ensure we do properly. We do regular backups so we can get data back in case of some failure, be it human, software, or hardware.… Read the rest
Continue reading »There are a couple of errors that you can get on database connection that simply mean you typed something wrong, but I figure there are people who will search on these errors, so I thought I would share. If you do not already have a database connection, you can get:
db2 conenct to SAMPLE DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command.… Read the rest Continue reading »