Hi, I have an application which opens a connection to the db, and then runs for some hours. Sometimes on win98 and NT connecting to the db takes about 20 seconds, but this can be reduced to about 4 seconds if I make an entry in the hosts file. Fine.
The problem is, that when the application is inactive for a while, it seems that the connection to the db is taken down, and reconnection of course takes again 4 seconds. Not so fine. Is there a parameter I can set when connecting to the db, or after the connection was established, so that the connection is kept alive "forever"? Regards, Axel > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Heinrich, Tilo > Sent: Freitag, 19. April 2002 11:28 > To: 'Hannes Degenhart' > Cc: sapdb general > Subject: RE: Problems with backup / restore > > > Hi Hannes, > > > 16:42 Full backup (migration) > > 16:44 Dataset 1 deleted > > 16:52 Dataset 2 deleted > > 16:53 db_cold > > > > Now starting different test with restore: > > - Restore backup until 16:47 (db_warm) ==> dataset 1 is available, > > dataset 2 not (Ok) > > Are you sure? Shouldn't that be dataset 1 unavailable, dataset2 available? > > > - db_cold > > - Restore backup until 16:43 ==> dataset 1 and dataset 2 are available > > (Ok) > > - db_cold > > - Restore backup until 16:53 ==> dataset 1 and dataset 2 are available > > (!!! Not Ok !!! or ?) > > - db_cold > > - Restore backup until 16:48 ==> dataset 1 and dataset 2 are available > > (!!! Not Ok !!! or ?) > > > > Could it be that after going back into the past with a recovery it is > > afterwards not possible to restore a later version with the same log? > > Yes, at least if you don't use log backups. If you "recover/restart until" > the database is forgetting about everything what happened after that. So to > say, it is as if nothing happened on the db after the until time. If you > really need to switch between different database states, you should backup > your log (before starting a recovery) and with the help of these log backups > you can then go back to any state you had before. > > Tilo Heinrich > SAP Labs Berlin > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
