List of Contributions

Keith Tidball

Progressive Insurance

Contact Details

Progressive Insurance

My Content

1 to 20 of 50+ total

RE: Call for User Panel Questions - March 12, 2024 Meeting

Posted By Keith Tidball Thu March 14, 2024 01:31 PM
Found In Egroup: InfoSphere Optim \ view thread
Hey RG, We were hoping you would attend the meeting to be part of the discussion. As Jimmy mentioned, there is nothing out of the box to allow for parametrized variables in a Column Map definition. One workaround that was brought up which may work for you is to employ the export/import utilities ...

Call for User Panel Questions - March 12, 2024 Meeting

Posted By Keith Tidball Tue February 27, 2024 10:51 AM
Found In Egroup: InfoSphere Optim \ view thread
It's that time again to gather ideas for the Panel Discussion segment of our quarterly OVUG meeting coming up on March 12. Please post ideas or questions as replies in this thread that you would like the Optim User Panel to discuss during the meeting. This is your opportunity to have your questions ...

RE: Call for User Panel Questions - Feb. 8 Meeting

Posted By Keith Tidball Wed February 07, 2024 03:09 PM
Found In Egroup: InfoSphere Optim \ view thread
Hey RG, The Tech Panel is part of the larger OVUG meeting which occurs once per quarter. The next meeting is slated for March and Marc Hebert will post the details once everything is finalized. -Keith ------------------------------ Keith Tidball Progressive Insurance --------------- ...

RE: rollback options for insert or load requests

Posted By Keith Tidball Tue January 16, 2024 11:26 AM
Found In Egroup: InfoSphere Optim \ view thread
Hey RG, I'm not quite sure what you mean by 'best rollback options' for Inserts and Loads since you are running these processes to ideally complete successfully? A Rollback will just undo any DB changes made since the last commit point and will not necessarily undo all the changes applied. ...

Call for User Panel Questions - September 19 Meeting

Posted By Keith Tidball Tue September 05, 2023 11:48 AM
Found In Egroup: InfoSphere Optim \ view thread
It's that time again to gather ideas for the Panel Discussion segment of our quarterly OVUG meeting coming up on September 19. Please post ideas or questions as replies in this thread that you would like the Optim User Panel to discuss during the meeting. This is your opportunity to have your questions ...

Override DB Alias used in an Archive Action

Posted By Keith Tidball Tue June 20, 2023 03:09 PM
Found In Egroup: InfoSphere Optim \ view thread
I'm working on a new Access Definition which will execute an Archive Action to invoke a stored procedure housed in a different DB Alias than the tables being archived in the AD. Is there a way to override the value of the DB Alias used in the archive action if it differs from the Default DB Alias?? ...

RE: Archive Request missing in IBM Optim after access was revoked in DB

Posted By Keith Tidball Fri June 16, 2023 02:16 PM
Found In Egroup: InfoSphere Optim \ view thread
Agreed this issue has nothing to do with the User ID against the source DB. It sounds like Binod did look in Optim and is not seeing the Archive Request or the Archive Collection. We have used Optim for years and never had objects just vanish from the Directory. Therefore, this usually means one of two ...

RE: Windows 2019 compatibility

Posted By Keith Tidball Wed April 05, 2023 11:44 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Phil, We run Optim v11.3.8 on Windows 2019 VMs and have not had any issues. -Keith ------------------------------ Keith Tidball Progressive Insurance ------------------------------

Call for User Panel Questions - April 11 Meeting

Posted By Keith Tidball Tue March 28, 2023 11:13 AM
Found In Egroup: InfoSphere Optim \ view thread
It's that time again to gather ideas for the Panel Discussion segment of our quarterly OVUG meeting coming up on April 11. Please post ideas or questions as replies in this thread that you would like the Optim User Panel to discuss during the meeting. This is your opportunity to have your questions ...

RE: IBM Optim Convert request change date column format

Posted By Keith Tidball Mon February 13, 2023 01:20 PM
Found In Egroup: InfoSphere Optim \ view thread
Another option is to CONVERT the date column in your Extract SQL. Not sure what the source data DBMS is, but most of them have ways to CONVERT date and time fields. A way to manipulate Optim to allow this is via a UNION ALL on the same table whereby the top part of the Union generates zero rows ...

RE: Archive Indexes Not Used by Attunity after Cutover to v11.7 z/OS

Posted By Keith Tidball Mon January 09, 2023 05:46 PM
Found In Egroup: InfoSphere Optim \ view thread
Some updates on this issue: 1. I was able to isolate the root cause as Optim wanting *all* of the archive files in a collection to be freshly imported into v11.7. Importing just some of the files won't work and Attunity will still run scans on all the archive files in the collection. 2. Optim ...

Archive Indexes Not Used by Attunity after Cutover to v11.7 z/OS

Posted By Keith Tidball Wed December 14, 2022 11:53 AM
Found In Egroup: InfoSphere Optim \ view thread
We recently cut over from Optim z/OS v11.3 to v11.7 for both Data Growth and TDM. We migrated Optim objects by making a copy of the v11.3 Directory DB and its contents. We then used the installation upgrade panels to upgrade all the Optim objects in the new, copied Directory DB in DB2 and it becomes ...

RE: Creation of Primary Keys not detecting while conversion

Posted By Keith Tidball Mon November 28, 2022 03:14 PM
Found In Egroup: InfoSphere Optim \ view thread
Your issue could be related to not using a numeric value for your SEQuence. The quotes around the number make it alphanumeric when it should be an integer. Try this: PROP(SEQ(32324322, 1)) Hope this helps.... ------------------------------ Keith Tidball Progressive Insurance --- ...

Call for User Panel Questions - Nov. 8 Meeting

Posted By Keith Tidball Tue November 01, 2022 02:29 PM
Found In Egroup: InfoSphere Optim \ view thread
It's that time again to gather ideas for the Panel Discussion segment of our quarterly OVUG meeting coming up on November 8. Please post ideas or questions as replies in this thread that you would like the Optim User Panel to discuss during the meeting. This is your opportunity to have your questions ...

RE: Call for User Panel Questions - July 19 Meeting

Posted By Keith Tidball Wed July 06, 2022 11:49 AM
Found In Egroup: InfoSphere Optim \ view thread
Questions below sent via DM to me from Engo for discussion on July 19. I am posting them here so other panel members may view them prior to the meeting: 1. Preparedness on the new OPTIM release 11.7 (Also an update progress on when it would be ready for us to make our plans for the year 2022). ...

Call for User Panel Questions - July 19 Meeting

Posted By Keith Tidball Tue July 05, 2022 01:16 PM
Found In Egroup: InfoSphere Optim \ view thread
It's that time again to gather ideas for the Panel Discussion segment of our quarterly OVUG meeting coming up on July 19. Please post ideas or questions as replies in this thread that you would like the Optim User Panel to discuss during the meeting. This is your opportunity to have your questions ...

RE: View extract file outside optim server

Posted By Keith Tidball Thu May 26, 2022 12:03 PM
Found In Egroup: InfoSphere Optim \ view thread
If you are not going to license ODM, then the only way you can view data in an Optim file is by using the Optim GUI to connect to it and then you may browse the contents. Beyond that, you can always load the file contents to a database or convert to a .csv file (in some cases) and then do whatever you ...

RE: View extract file outside optim server

Posted By Keith Tidball Thu May 26, 2022 10:45 AM
Found In Egroup: InfoSphere Optim \ view thread
Open Data Manager (ODM) and Optim Connect are needed to view an archive file or collection via Optim Connect Thin Client (ODBC/JDBC DSN) . Not sure it will work on Extract or Compare files. However, I don't think ODM works without Optim Data Growth on the machine in question where the archive files are ...

RE: DB Alias Log On Information

Posted By Keith Tidball Wed February 23, 2022 04:42 PM
Found In Egroup: InfoSphere Optim \ view thread
It may depend on the DBMS and the method you're using to authenticate on the connection string. For example, when I connect to SQL Server using ODBC DSN, I select integrated Windows authentication in the DSN definition. This then uses the current credentials from the machine you're logged onto (client ...

Call for User Panel Questions - Feb. 8 Meeting

Posted By Keith Tidball Mon February 07, 2022 10:57 AM
Found In Egroup: InfoSphere Optim \ view thread
Sorry for the late post on this! It's that time again to gather ideas for the Panel Discussion segment of our quarterly OVUG meeting coming up on February 8. Please post ideas or questions as replies in this thread that you would like the Optim User Panel to discuss during the meeting. This is your ...