DB2 datasource fails to connect after system backup

[nitsuj]

I've googled and searched the forums without finding a solution so here goes:

I'm having trouble with my CFMX 6.1 production server connecting to our main
AS400 database server via the iSeries ODBC connector. The AS400 is backed up
nightly starting at 11:30pm and ending around 1am. A few minutes after the
AS400 backups start, I the CF dsn to the AS400 can no longer connect to it.
That's expected because the server refuses all connections during backup.

But once the backup is done, CF still can't connect to the AS400 until I
manually go into CF Administrator, click to edit the dsn and then save it
without making changes. That somehow resets the connection and everything works
just dandy... until the next backup!

Any ideas on how to "reset" the connection after the backup? Thanks!

CONFIGURATION:
CFMX 6.1 Standard on Win2003 Standard
AS400 iSeries V5R3M0 connecting with iSeries Access ODBC driver version
10.00.02.00 (9/2/2004)

[nitsuj]

I solved it by scheduling a batch file on the web server to restart ColdFusion
after backups on the AS400 have finished. Restarting the CF server effectively
resets the DSN connection to the AS400, so problem solved! It's not the most
elegant solution but it's simple and it works.

I got the code for the restart batch file at:

[url]https://www.cfdev.com/code_samples/code.cfm/CodeID/72/ColdFusion/Bat_file_to_res[/url]
tart_ColdFusion_MX