List of Contributions

Keith Tidball

Progressive Insurance

Contact Details

Progressive Insurance

My Content

1 to 20 of 50+ total
Posted By Keith Tidball Aug 4, 2020 3:24 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
Thank you for the additional details. We still run Optim as 32-bit; even on 64-bit Windows servers, so we haven't hit the bitness issue you ran into with archive files. The 32-bit version runs fine for us, so it may be possible to redo your installation to run as 32-bit and then you can easily move any ...
Posted By Keith Tidball Aug 3, 2020 12:01 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
Gary, will you please add some additional details on what you're trying to do? Subject line says you are archiving SQL Server and creating an archive collection, but content of your post is saying you're having an issue registering an archive file created on a different server and then ask about connecting ...
Posted By Keith Tidball Jul 27, 2020 3:45 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
Last chance to submit questions to be discussed tomorrow during the User Panel. Please respond to this thread to post your questions. Thanks and talk with everyone tomorrow at the OVUG meeting. ------------------------------ Keith Tidball Progressive Insurance ------------------------------
Posted By Keith Tidball Jul 17, 2020 2:18 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
Panel question posted by David Mogashoa: "We are currently archiving our data to HCP storage which is on premises. I would like to know if Optim is capable to archive to Amazon S3 Glacier in the cloud." ------------------------------ Keith Tidball Progressive Insurance ----------------------------- ...
Posted By Keith Tidball Jul 17, 2020 2:06 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
Fred's point about being careful with selecting a portion of the data via a view is a valid issue if this is meant to be a true archive. That being said, we have used views that don't entirely match the underlying table columns and it has worked in Access Definitions, so these errors may be for other ...
Posted By Keith Tidball Jul 13, 2020 2:11 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
It's that time again to gather ideas for the Panel Discussion segment of our quarterly OVUG meeting coming up on July 28. Please post ideas or questions as replies in this thread that you would like the Optim User Panel to discuss. This is your opportunity to have your questions addressed by multiple ...
Posted By Keith Tidball Jun 29, 2020 3:58 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
I suspected as much, thank you for confirming this. -Keith ------------------------------ Keith Tidball Progressive Insurance ------------------------------
Posted By Keith Tidball Jun 29, 2020 12:19 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
I'm working on a new Access Definition using Optim Data Growth 11.3 z/OS against DB2. There are about 10 tables in the AD and we noticed during testing that Optim is issuing commits during the Delete phase after each table is completed...which is far below the commit threshold. We expected Optim to just ...
Posted By Keith Tidball May 12, 2020 3:55 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
FYI, There is now an iFix to address this data corruption. We have tested it and it appears to work and resolved the last byte of data getting altered. It is part of iFix 94 for Optim 11.3.0.7 (fixpack 7). ------------------------------ Keith Tidball Progressive Insurance ------------------------- ...
Posted By Keith Tidball May 4, 2020 11:40 AM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
Before you expand the key limits, you should verify Optim is using sound execution paths against the tables. Optim is executing SQL under the covers, so if you see tables taking a long time to run you need to get back to some basic SQL query principles. Is your query on the Start table using an ...
Posted By Keith Tidball Apr 22, 2020 12:18 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
The Data Byte Count in the archive report should be the byte count Optim read from your source. If you are unsure, just look at the byte count in the report to the actual byte count of the file you created by looking at the file in File Explorer or similar file/folder tool. If compression is on, the ...
Posted By Keith Tidball Apr 16, 2020 1:02 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
It's that time again to gather ideas for the Panel Discussion segment of our quarterly OVUG meeting coming up on April 28. Please post ideas or questions as replies in this thread that you would like the Optim User Panel to discuss. This is your opportunity to have your questions addressed by multiple ...
Posted By Keith Tidball Apr 14, 2020 5:14 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
Creating a View is done within the DBMS and then, yes, you reference the View and not the actual table in your Optim AD. You will need to check off the Optim product option to allow you to create Optim relationships against Views, too. ------------------------------ Keith Tidball Progressive Insurance ...
Posted By Keith Tidball Apr 13, 2020 3:22 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
VARCHAR & NVARCHAR are different datatypes under the covers, so I'm not surprised Optim won't allow the relationship. We have gotten around some issues like this by creating a table VIEW and then casting the NVARCHAR column to be VARCHAR in the View Definition. Then create the Optim relationship ...
Posted By Keith Tidball Apr 10, 2020 2:16 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
Curious if anyone is using or has created logic to find sensitive or PII data within free-form text strings. An example of this could be chat window information between a customer and a service rep whereby a customer could potentially enter sensitive information which gets saved into the repository holding ...
Posted By Keith Tidball Mar 31, 2020 11:21 AM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
We have seen ODPP choke on such values, so we have code that evaluates the value of the field prior to masking it. If the value is blank or null, then just leave it as-is and don't try to mask it and move to the next record. ------------------------------ Keith Tidball Progressive Insurance ------ ...
Posted By Keith Tidball Mar 31, 2020 11:08 AM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
Optim uses dynamic SQL in their various stored procs to open cursors against the target tables. Columnstore Indexes do not support cursor processing, so I'm not surprised Optim is throwing this error. I am not sure if Optim excludes these from Archives, but given its reliance on cursor processing I wouldn't ...
Posted By Keith Tidball Feb 28, 2020 10:03 AM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
I don't believe that is possible with Optim Connect...and even if it were possible, I'd advise against it. We've found some shortcomings with Optim's memory management when attempting to run queries on too much underlying data inside an archive collection. You need to keep in mind that you are not getting ...
Posted By Keith Tidball Feb 21, 2020 12:49 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
We actually were able to get the View to work properly in the Access Definition. There is a Product Options setting to allow this (why it is not a default, I have no idea). 1. Go into 'Product Options' 2. Open 'Database' Tab. 3. Check off the 'Allow Optim PK/Rels on Db Views' 4. Restart Optim Once ...
Posted By Keith Tidball Feb 14, 2020 4:04 PM
Found In Egroup: Optim - Test Data Management and Archiving
\ view thread
While working on resolving the issue I recently posted about Optim corrupting NVARCHAR(MAX) data fields, I decided that we could possibly work around this issue in the short term by creating a View against the table with the NVARCHAR data and CAST that column as VARCHAR(MAX) since Optim handles VARCHAR ...