List of Contributions

Saradhi Motamarri

Contact Details

My Content

1 to 20 of 39 total
Posted By Saradhi Motamarri May 30, 2020 6:11 AM
Found In Egroup: Informix
\ view thread
Hi Paul and Eric, Thank you. Yes, guessed the typo in Doug message. :)
Posted By Saradhi Motamarri May 30, 2020 5:30 AM
Found In Egroup: Informix
\ view thread
Hi Doug, That's great insight. Thank you so much for the clarifications.
Posted By Saradhi Motamarri May 30, 2020 3:57 AM
Found In Egroup: Informix
\ view thread
Hi Doug, Thank you so much for your response. Yes, $onmode -m brought the instance to On-Line, and chunks in PO-B- Mode. Looks all good. I have a doubt here: a. ontape -p -t, should have come to Quiescent mode? b. onmode -m, looks like actually brought the instance from Fast Recover to On-Line. c. So, ...
Posted By Saradhi Motamarri May 30, 2020 3:25 AM
Found In Egroup: Informix
\ view thread
Hi All, I was doing a trial restore. Using: nohup ontape -p -t STDIO < backupfile & File size is about 79,883 MB What I noticed in the message log is that 07:32:22 Physical Restore of rootdbs started. ---- --- 08:13:15 Physical Restore of rootdbs Completed. -- -- 08:13:15 Maximum server connections ...
Posted By Saradhi Motamarri May 28, 2020 9:05 AM
Found In Egroup: Informix
\ view thread
Thank you, Art.
Posted By Saradhi Motamarri May 28, 2020 8:00 AM
Found In Egroup: Informix
\ view thread
Hi Doug, Thank you for the valuable advice. Yes, there is no need to apply logical logs.
Posted By Saradhi Motamarri May 28, 2020 7:40 AM
Found In Egroup: Informix
\ view thread
Hi Doug and Alexandre, Thank you. Level-0 backup, say databackup (about 80GB), is restored on to a file system on the DR server. Are you saying, $nohup ontape -p -t STDIO < databackup is the command to use, than $ontape -r [assuming TADEDEV=databackup]? When we run ontape -r commoand, it prompts some ...
Posted By Saradhi Motamarri May 28, 2020 2:20 AM
Found In Egroup: Informix
\ view thread
Hi Paul, Could you please, elaborate what is meant by running the command in a screen?
Posted By Saradhi Motamarri May 27, 2020 11:56 PM
Found In Egroup: Informix
\ view thread
Hi, As part of a Disaster Recovery Exercise, need to restore large instances (about 80GBs) remotely. Now there are multiple issues here: 1. The remote connection may time-out due to terminal session time limit, 2. VPN time limit; or 3. Some Internet issue. What are the best ways to run 'ontape -r' remotely? ...
Posted By Saradhi Motamarri May 19, 2020 9:16 AM
Found In Egroup: Informix
\ view thread
Thank you Art for the insights.
Posted By Saradhi Motamarri May 19, 2020 12:33 AM
Found In Egroup: Informix
\ view thread
Hi Casey and Paul, Thank you. It works now, after adjusting the size to free pages. With the best regards and thanks, Saradhi Motamarri +61430022130 Sent from Yahoo Mail for iPhone
Posted By Saradhi Motamarri May 18, 2020 10:38 PM
Found In Egroup: Informix
\ view thread
Hi, I have created a test instance on IDS 11.50. Then, I have created a new dbspace phylogs. And added a raw chunk of 1024 MB to it. When I execute: $ onparams -p -d phylogs -s 1048552 I am getting the following error: Physical log size specified is too large. Are there any specific limits on the size ...
Posted By Saradhi Motamarri May 15, 2020 3:56 AM
Found In Egroup: Informix
\ view thread
Hi Paul, Khaled and Art, Thank you.
Posted By Saradhi Motamarri May 14, 2020 9:19 AM
Found In Egroup: Informix
\ view thread
Hi All, In dbaccess when we traverse to 'Connection' tab, it lists a set of Informix Servers available. From where does dbaccess picks up this available servers?
Posted By Saradhi Motamarri May 7, 2020 6:26 AM
Found In Egroup: Informix
\ view thread
Hi Doug, Thank you.
Posted By Saradhi Motamarri May 5, 2020 10:50 PM
Found In Egroup: Informix
\ view thread
Thank you Art.
Posted By Saradhi Motamarri May 5, 2020 9:55 PM
Found In Egroup: Informix
\ view thread
Thank you SangGyu.
Posted By Saradhi Motamarri May 5, 2020 9:03 PM
Found In Egroup: Informix
\ view thread
Hi Art, I read in one of your posts that to reclaim table/ index space after a deletes, needs to run the API function ("table shrink") and ("index shrink") manually. Is this process can be run for an entire database (as many tables might have been cleaned in a purge operation)? How heavy this operation, ...
Posted By Saradhi Motamarri Apr 30, 2020 7:21 AM
Found In Egroup: Informix
\ view thread
Thank you Andreas.
Posted By Saradhi Motamarri Apr 29, 2020 3:22 PM
Found In Egroup: Informix
\ view thread
Hi Art, Thank you for your insightful clarifications. Thoroughly appreciate your help. With the best regards and thanks, Saradhi Motamarri +61430022130 Sent from Yahoo Mail for iPhone