XTIVIA BLOG
Using SQL in DB2 to Write REORG Statements
DB2's automated maintenance does not currently allow us to automate inplace reorgs. Inplace reorgs are more online than other reorgs, and in my experience are heavily used. This means that many DBAs wrap some sort of scripting around reorgs. Working in a variety of client...
ORA-00936: missing expression
This error comes up pretty often and can be caused by a lot of different things. Usually, this is a pretty easy one to solve. It's mostly just a syntax error and you forgot part of your SQL statement. You need a select, a column, from clause, and optionally a where clause to...
Using the XTIVIA Services Framework For Liferay REST Services
Introduction This article is the first in a series of articles that describes the XTIVIA Services Framework (XSF). XSF is a framework that XTIVIA has created and used for multiple client engagements. XSF enables the rapid development of application REST services in...
Tip #4 – Not having a Baseline – Top 10 Tips for SQL Server Performance and Resiliency
Tip # 4 – Not having a Baseline Top 10 Tips for SQL Server Performance and Resiliency This article is part 4 in a series on the top 10 most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I see and...
ORA-03113 end-of-file on communication channel
This error occurs due to the fact that your connection to the Oracle server is no longer available or that the server couldn't respond to the client's requests. This is usually called by an Oracle server issue or a networking issue. You can start troubleshooting by making sure...
ORA-01722 Invalid Number
ORA-01722 Invalid Number This error occurs when you try to convert a character string into a number, and the string can't be converted into a valid number. So what is a valid number you ask? A valid number to Oracle would be a digit between 0-9, a negative or positive sign at...
SQL Server Cursor Example – SQL Toolbox
Cursors in SQL Server allow developers to iterate through a collection of values, normally based off a select statement. This is very useful for scripts that must apply to many items at once. More often than not that is iterating through database names to make changes to each...
ORA-00600
The ORA-600 is an internal Oracle error that can be reported by a very serious error. A lot of times this error can't be solved by an onsite DBA and needs direct help from Oracle to help troubleshoot the issue. If the trace files from the error don't prove to be useful in...
Tip # 3 – Maintain your SQL Server – Top 10 Tips for SQL Server Performance and Resiliency
Tip # 3 – Maintain your SQL Server Top 10 Tips for SQL Server Performance and Resiliency This article is part 3 of 10 in a series on the most common mistakes that I have seen impacting SQL Server Performance and Resiliency. This post is related to the most common errors I see...
ORA-12154: TNS:could not resolve the connect identifier specified
ORA-12154: TNS:could not resolve the connect identifier specified This is one of the most common Oracle errors and it is basically telling you that you are trying to connect to a database name that is unknown to the system. The most common cause are typos in your connection...