Db2 Experts on a Data Science Quest
 |
 |
 |
 |
 |
 |
The IDUG Conference in Charlotte this year was one of the best-run North American Conferences I have been to. They rose close to the high standard that the IDUG European conference committee sets. I had fewer issues with how things ran.… Read the rest
Continue reading »
This is my regular pre-conference blog entry. I write these every year to share details about the conference and to share my excitement for this form of education and networking. The IDUG conferences in the US and Europe are my favorite weeks of the year.… Read the rest
Continue reading »
I’m a command line gal, and probably always will be. I doubt a GUI will tempt me away from the command line, though I do find myself enjoying using things like Jupyter Notebook to also access the databases I support.
I learn something new every day. The times I’m most surprised about what I learn is when it happens to be something pretty fundamental about how Db2 uses resources.
This situation happened on an AIX environment I’m mentoring someone to build.… Read the rest
Continue reading »While I’ve covered this topic in detail, and blogged about a specific backup performance problem, I’ve never talked about this at the basics level.
A backup is a binary image of the entire Db2 database.… Read the rest
Continue reading »
This is a new series that has been percolating in my head for a while. When I help clients with SQL, we’re often adding (or removing) indexes to help SQL performance. It has been said (though not by me) that SQL re-write is obsolete because the Db2 Optimizer will take care of that.… Read the rest
Continue reading »
I’ve been moving along well this year on my data science journey. I’ve been thoroughly enjoying an edX class: Python for Data Science from UC San Diego. I started using Jupyter Notebooks (Python Kernel) over a year and a half ago, so I am enjoying the course on three levels:
Learning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confound others.… Read the rest
Continue reading »
Learning SQL can feel intimidating, even to some experienced DB2 DBAs. For years, you could administer Db2 without using SQL. There are a lot of developers, too who want to learn SQL. The set-thinking of SQL can be confusing. The complete detachment from the physical layer can confound others.… Read the rest
Continue reading »