List of Contributions

Danny Lankford

3M

Contact Details

My Content

1 to 20 of 50+ total

RE: Call for User Panel Questions - January 26 Meeting

Posted By Danny Lankford Jan 19, 2021 12:22 PM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Keith, We came up with another topic that we wanted to inquire about. The question is "how are others handling multiple archivists, say, 5 simultaneous server archivists on one Optim Archive Server?" Our team is expanding to include more archivists. Let's say for discussion sake, as many as 5 at ...

RE: Call for User Panel Questions - January 26 Meeting

Posted By Danny Lankford Jan 11, 2021 3:27 PM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Keith, I'm in the planning phase of migrating all of our Optim Infrastructure to AWS. Is there any way that we can poll the group to see how many folks are in the process to migrate to cloud or are all ready there? This is not really a typical how-to forum question. Just a curiosity. Thanks, ----- ...

RE: Call for User Panel Questions - July 28 Meeting

Posted By Danny Lankford Jul 20, 2020 9:56 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Keith, My two cents, Cloud, cloud, cloud, Planned vendor support, if any, Firsthand experience so far, if any, Optim cloud roadmap, timeline, if any, Did I mention cloud yet? Thanks, Danny L. Lankford | IT Manager IT Quality, Information Technology 3M Center, 224-4E1 | St. Paul, MN 55144 | United ...

RE: Issue with column's having ORA_NUMBER Data types

Posted By Danny Lankford Apr 27, 2020 10:41 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Interesting. Following. I assume that you have a ticket open with support as well right? ------------------------------ Danny Lankford 3M - IT Manager ------------------------------

RE: Query Archives without DBVisualizer

Posted By Danny Lankford Apr 23, 2020 1:27 PM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Donna, What happens when you export the *LOB straight from the source, using the Optim Classic Client GUI? CLOB's can have all kinds of data elements in them that 100% cannot be interacted with using just any DB client. In many cases you need an application layer to present the data back to a user. ...

RE: Call for User Panel Questions - April 28 Meeting

Posted By Danny Lankford Apr 21, 2020 9:30 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Keith, Support and or "certification of support" for hosting Optim on cloud infrastructure. We are in the process of shifting and re-provisioning all of our infrastructure to AWS cloud hosted infrastructure. Note* this is public knowledge. While I realize that we could, in theory, put Optim on AWS ...

RE: Query Archives without DBVisualizer

Posted By Danny Lankford Apr 21, 2020 9:03 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
HI Donna, No tree expansion twisty. When an object is selected in the pane, it becomes expanded on the window to the right. I don't believe that there is a config setting to change this behavior to look like say... SQL server client, MS SQL Studio Management client. See the screen capture. Danny ...

RE: Query Archives without DBVisualizer

Posted By Danny Lankford Mar 24, 2020 12:47 PM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Yes. http://querytool.com/features/tour4.html#lobs look at the features link. you can export *LOBs to files or view them right in the AQT tool. pretty handy. There's some cool export functions to script the exports as well. ------------------------------ Danny Lankford 3M - IT Manager ------------ ...

RE: Query Archives without DBVisualizer

Posted By Danny Lankford Mar 24, 2020 10:53 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
I'm a fan of AQT Advanced Query Tool. http://querytool.com/index.html It also comes in handy as a multi-database tool. JDBC/ODBC File DSN, Weird Direct Connect stuff, Etc. The v10 with extended features is awesome. ------------------------------ Danny Lankford 3M - IT Manager --------------------- ...

RE: Convert Request Optimization

Posted By Danny Lankford Mar 20, 2020 2:53 PM
Found In Library: Optim - Test Data Management and Archiving

RE: Convert Request Optimization

Posted By Danny Lankford Mar 20, 2020 2:53 PM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
From a pure Optim settings perspective I would say start with these attached docs. Use them as reference. Experiment on non-prod systems. For what it's worth, you can modify some of the following configuration parameters shown below. I've found that we can significantly change the performance of Optim ...

RE: Any pans to containerize Optim

Posted By Danny Lankford Mar 11, 2020 9:34 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Thanks for the reply Peter. Danny L. Lankford | IT Manager IT Quality, Information Technology 3M Center, 224-4E1 | St. Paul, MN 55144 | United States Office: +1 651 733 8489 dllankford@mmm.com

RE: Any pans to containerize Optim

Posted By Danny Lankford Mar 3, 2020 9:46 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Bump. I have the same question. I have been asked to prepare to move our infrastructure to cloud in the next 2 years. We've selected AWS as our vendor. @Peter Costigan Is this in the roadmap? Thanks, Danny​​ ------------------------------ Danny Lankford 3M - IT Manager ----------------------------- ...

RE: Using Views in Access Definition

Posted By Danny Lankford Feb 18, 2020 12:30 PM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Thanks for sharing Keith and yes, We've run into issues creating views of tables for archiving purposes. Unfortunately, in some cases, we had to create a new table, migrate data to the new table and "gently transform" the data types to play nice with Optim. While this isn't a good best practice, it does, ...

RE: Optim Licensing

Posted By Danny Lankford Feb 12, 2020 11:04 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Thought i'd share just a wee-bit more detail on this from our experience because I wish someone would have done this for me.Our specific area of licenses usage is Datagrowth. For years I was unable to get a solid answer on this licensing situation with Optim. I know what I'm invoiced for and what we ...

RE: Handling Oracle ORDIMAGE Datatype using Optim

Posted By Danny Lankford Jan 29, 2020 5:29 PM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Yes, we've run into this one and various other data types like BLOB, CLOB, IMAGE, MEDIA, etc.. from various databases. We have often found that the actual data inside one of the fields is not supported by the source database and would also throw errors if you try to query it directly from a DB client. ...

RE: Optim Connect Data Providers.

Posted By Danny Lankford Jan 24, 2020 11:54 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Arg, I think I figured it out. I could be wrong but through a time consuming process of multiple Optim connect installation scenarios (from an upgrade scenario versus a fresh install scenario) the ODBC, DB2, and Oracle providers are not available with a "Fresh" build 53 install. (Which was delivered ...

Optim Connect Data Providers.

Posted By Danny Lankford Jan 23, 2020 2:39 PM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
I have an open case for this issue but so far Optim support has no answer. Anybody else experience this? Take a look at the screen capture. Both laptops are Windows 10. Both are Optim Connect Studio 5.3.3 build 53. Both have the exact same Optim Connect license. Yet, the available data providers ...

RE: IDMS archival requirement

Posted By Danny Lankford Jan 10, 2020 10:47 AM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Yes, data can be accessed via several methods once it has been archived to Optim no matter if it's relational or hierarchical . That's literally the purpose for archiving for retirement. Optim ODBC/JDBC drivers allow for pretty much any DB client to access the archives but you need a proxy like Optim ...

RE: Issue with Optim 11.3.5 archiving to EMC storage

Posted By Danny Lankford Jan 9, 2020 2:02 PM
Found In Egroup: Optim - Test Data Management and Archiving \ view thread
Which Optim connect ODBC/JDBC driver are you using? I would assume that you're using JDBC since DBViz prefers JDBC drivers. Can you query the archive file via Optim Connect Studio? What Data Source Type have you defined in Optim Connect Studio? Optim Connect ODBC Thin Client 2.5 or 3.5? OR Optim ...