Good morning, I hope you're all having an amazing day!
Maximo Community,
I'm currently working on a batch file to automate a daily backup for our DB2 backend data for our Maximo/MAS SaaS PROD environment through a Windows batch file. The goal is to connect to our sensitive reportdb environment (which is a replica database) to perform some routine tasks. However, I'm facing issues with the connection part of the script. The script as it currently runs produces a blank backup, which tells me the script didn't connect to the backend. The goal is to automate the backing up of all tables to a single backup and run it on an environment that is running on my desktop. A batch file allows me to use Windows system programs to manage it, as well as run it on-demand as needed. I will be running this on multiple machines.
Here's the situation:
-
I've written a batch file that should, in theory, connect to DB2 and execute the necessary commands.
-
The batch file runs without errors, but it doesn't successfully connect to the reportdb database.
- I do not know DB2 as well as the open source SQL servers like PostgreSQL, MySQL, or even Oracle or MS SQL Server. If it was MySQL or PostgreSQL it would be solved already.
Due to security policies, I can't share the exact script here as it includes sensitive information like passwords and SSL details. However, I'm looking for advice or best practices on:
- DB2 suite proprietary programs and how to navigate them to know what to use for this.
-
DB2 Connection in Batch Files: What are some common pitfalls when setting up a connection to a DB2 database from a Windows batch file?
-
Environment Setup: How do you ensure the DB2 environment is correctly initialized for script execution?
-
Security Considerations: Any tips on managing credentials securely within a script or how to handle SSL connections? I thought I had it in there but something must be wrong.
Any insights or experiences from those who have dealt with similar issues would be greatly appreciated. I'm particularly interested in hearing how others have approached securing their scripts or any DB2-specific commands that might help with troubleshooting. We are dealing with a system hosted by IBM so, as you ca imagine, support has been obstinately kicking up roadblocks but I coded this thing to connect to the reportDB (replica) environment I use for reporting and analytics.
Thank you for any help or guidance you can provide! Please let me know if I can clarify anything. I am trying to take the sensitive information out so I can post what I have here.
Best Regards,
Phil
#Analytics#Customizations#Integrations#Reporting------------------------------
Philip Marrone
Boston Children's Hospital
------------------------------