Jeffrey Snover:- “Engineering Encounters with reality”

Who is Jeffrey Snover? Link Jeffrey Snover is a Microsoft Technical Fellow, PowerShell Chief Architect, and the Chief Architect for the Azure Infrastructure and Management group which includes Azure Stack, System Center, and Operations Management Suite.  Snover is the inventor of Windows PowerShell, an object-based distributed automation engine, scripting language, and command-line shell, and was … Continue reading Jeffrey Snover:- “Engineering Encounters with reality”

Db/2 – Error – “SQL Error [42725]: Reference to routine was made without a signature, but the routine is not unique in its schema.. SQLCODE=-476”

Background Trying to manage a routine and ended up with the error listed below. Error Error Image Error Text Recreate Issue SQL Code Syntax Example Trouble Shooting Objective Let us determine the signatures for our referenced object, SYSPROC.SNAP_GET_DB. SQL Identify Routine Parameters Code Output Explanation ROUTINESCHEMA SYSPROC ROUTINENAME SNAP_GET_DB SPECIFICNAME SNAP_GET_DB SNAP_GET_DB_AP LANGUAGE C IMPLEMENTATION db2monudf!snap_get_db … Continue reading Db/2 – Error – “SQL Error [42725]: Reference to routine was made without a signature, but the routine is not unique in its schema.. SQLCODE=-476”

Db/2 LUW & DBeaver – Error – An error occurred during implicit system action type “2”

Background Trying to run Explain on a Db/2 query, but running into an error. Error Error Image Error Text Troubleshooting Unselected Text When we try to explain the Query without selecting the text we get the error pasted below: Image Text Remediation Select Text Please select the text you want explained and click the "Explain … Continue reading Db/2 LUW & DBeaver – Error – An error occurred during implicit system action type “2”

Dbeaver / Date Format

Background Quick follow-up to our last post on String Representation of datetime. Referenced Post BTW, that post is here: Db/2 – LUW – SQL Error [22007]: “The string representation of a datetime value is out of range” Link Goal In this post we will discuss options for displaying date columns in "locale" sensitive ways. Implementation … Continue reading Dbeaver / Date Format

DBeaver – Database Connection Configuration – IBM – DB2 / UDB JDBC Driver

Background As always coming back to DBeaver. This time to connect to a UDB Instance running on Linux. BTW, UDB means Universal Database. UDB JDBC Driver Artifacts DB2 JDBC Driver Versions and Downloads The URL for DB2 JDBC Drivers is Link. Here is a current snapshot. v11.1 FP0 ( GA ) We chose the v11 … Continue reading DBeaver – Database Connection Configuration – IBM – DB2 / UDB JDBC Driver

Renaissance Technologies

Background As I browsed the Internet, found out that Robert Mercer is giving up his day job as a CEO. And, returning to being a researcher. Tradition His trajectory follows that of some before him. Notably Bill Gates, at 55 years old, self demoted from Microsoft CEO to Founder and Technology Adviser. And, Larry Ellison … Continue reading Renaissance Technologies