Welcome to ACE DBA Consulting LLC

DATA Studio 3.2 : Backup removal script scheduling

Posted on January 20, 2014 by Renu Sharma

Recently while working for one of my financial customers, I was struggling with a lack of documentation for DATA STUDIO 3.2 web console job scheduling. The task given was to delete the backup images, delete the db cfg , dbm cfg, and db2look , which were taken seven

more

No comments

Altering table Flavours

Posted on October 30, 2013 by Renu Sharma

Yesterday doing alter column for an ecommerce client of mine I was asked to remove the generated always IDENTITY key from a table. Secondly asked to add a column for a name column where the added column UCASE_NAME will always have alphabets translated to upper case. Third to alter an

more

No comments

Load using database option of load cursor

Posted on April 09, 2013 by Renu Sharma

Today's blog is about load using database option of load cursor When would I use this option? I don’t have federation license. I don’t have enough disk space for exports. I want ease of use (No federation setup). I want better performance as this load type uses fewer layers then federation.

more

2 comments

Blog