Professional Web Applications Themes

DB2 datasource fails to connect after system backup - Coldfusion Database Access

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 ...

  1. #1

    Default DB2 datasource fails to connect after system backup

    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 Guest

  2. #2

    Default Re: DB2 datasource fails to connect after system backup

    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

    nitsuj Guest

Similar Threads

  1. Coldfusion 5: Connect to Oracle 9i datasource
    By JaysonJoseph in forum Coldfusion Server Administration
    Replies: 0
    Last Post: September 7th, 10:14 PM
  2. Datasource and scheduled task backup
    By Ellis75 in forum Coldfusion Server Administration
    Replies: 0
    Last Post: April 19th, 08:01 AM
  3. Hard Drive Failure -- System Backup
    By Scott in forum Windows XP/2000/ME
    Replies: 6
    Last Post: July 14th, 02:40 AM
  4. Backup XP box to Debian system
    By Carl Fink in forum Debian
    Replies: 7
    Last Post: July 1st, 05:00 PM
  5. RMAN archivelog backup fails
    By Rudi in forum Oracle Server
    Replies: 0
    Last Post: June 28th, 03:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139