Dbimport a database in an hdr
Hi,
I try to upload a databaae in an hdr environment using dbimport in the primary
server. When it finish, I go to the secondary server but I cant access it. It
say database doesn't found or no connect permission. How can I do to upload
this database correctly?
Thanks in advance.
Did you run the dbimport with the "-l" (lower case "L") to make sure that it
was created with logging?
If you did not, then the database would have been created with NO logging
and would not be replicated over to the secondary server.
Mike Walker
Advanced DataTools Corporation
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of jorge
valenzuela
Sent: Wednesday, February 21, 2018 7:16 PM
To: ids@iiug.org
Subject: Dbimport a database in an hdr [40727]
Hi,
I try to upload a databaae in an hdr environment using dbimport in the
primary server. When it finish, I go to the secondary server but I cant
access it. It say database doesn't found or no connect permission. How can I
do to upload this database correctly?
Thanks in advance.
****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.
When I used dbimport with the "l" option, I get a long transaction aborted
error. How can avoid this error?
Thanks.
> El 21/02/2018, a las 18:29, Mike Walker <mike@advancedatatools.com> escribió:
>
> Did you run the dbimport with the "-l" (lower case "L") to make sure that it
> was created with logging?
>
> If you did not, then the database would have been created with NO logging
> and would not be replicated over to the secondary server.
>
> Mike Walker
> Advanced DataTools Corporation
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of jorge
> valenzuela
> Sent: Wednesday, February 21, 2018 7:16 PM
> To: ids@iiug.org
> Subject: Dbimport a database in an hdr [40727]
>
> Hi,
> I try to upload a databaae in an hdr environment using dbimport in the
> primary server. When it finish, I go to the secondary server but I cant
> access it. It say database doesn't found or no connect permission. How can I
> do to upload this database correctly?
>
> Thanks in advance.
>
> ****************************************************************************
> ***
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
You can try to add more logical logs (onparams -a....) but, if you
import big database, i think the only solution was:
- stop HDR
- import database
- bring it to logging mode (ontape -s -L 0 -U database -t /dev/null)
- reinitialize HDR
On 22.02.2018 06:22, jorge valenzuela wrote:
> When I used dbimport with the "l" option, I get a long transaction aborted
> error. How can avoid this error?
> Thanks.
>
>> El 21/02/2018, a las 18:29, Mike Walker <mike@advancedatatools.com>
> escribió:
>> Did you run the dbimport with the "-l" (lower case "L") to make sure that it
>> was created with logging?
>>
>> If you did not, then the database would have been created with NO logging
>> and would not be replicated over to the secondary server.
>>
>> Mike Walker
>> Advanced DataTools Corporation
>>
>> -----Original Message-----
>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of jorge
>> valenzuela
>> Sent: Wednesday, February 21, 2018 7:16 PM
>> To: ids@iiug.org
>> Subject: Dbimport a database in an hdr [40727]
>>
>> Hi,
>> I try to upload a databaae in an hdr environment using dbimport in the
>> primary server. When it finish, I go to the secondary server but I cant
>> access it. It say database doesn't found or no connect permission. How can I
>> do to upload this database correctly?
>>
>> Thanks in advance.
>>
>> ****************************************************************************
>> ***
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
--
Untitled Document
*Ivan Zavi*
/System Administrator/
+381 21 68 98 608 | +381 69 846 99 08
*M&I Systems, Co. Group*
Bulevar vojvode Stepe 16, 21000 Novi Sad, Srbija
+381 21 68 98 602 | +381 21 68 98 604
info@mi-system.co.rs | www.mi-system.co.rs
Odricanje od odgovornosti:
Ovaj dokument namenjen je samo licima kojima je upucen i za pozivanje na
isti od stane bilo kog lica, neophodna je naknadna pismena potvrda
njegovog sadraja. Shodno tome, M&I Systems, Co. Novi Sad odrice svaku
odgovornost i ne prihvata bilo kakvu obavezu (ukljucujuci slucaj
nepanje) za posledice koje moe pretrpeti bilo koje lice zbog cinjenja
ili necinjenja na bazi takve informacije pre nego to takva lica prime
dodatnu pismenu potvrdu. Ukoliko ste grekom primili ovu elektronsku
poruku, unitite ili izbriite istu sa vaeg racunara. Svako umnoavanje,
irenje, kopiranje, obelodanjivanje, izmene, distribucija i/ili
objavljivanje ove elektronske poruke je strogo zabranjeno. Sadraj ove
elektronske poruke ne predstavlja nuno stavove M&I Systems, Co. Novi Sad
Thanks you very much.
> El 21/02/2018, a las 23:35, Ivan Zavis <ivan.zavis@mi-system.co.rs> escribió:
>
> You can try to add more logical logs (onparams -a....) but, if you
> import big database, i think the only solution was:
>
> - stop HDR
>
> - import database
>
> - bring it to logging mode (ontape -s -L 0 -U database -t /dev/null)
>
> - reinitialize HDR
>
>> On 22.02.2018 06:22, jorge valenzuela wrote:
>> When I used dbimport with the "l" option, I get a long transaction aborted
>> error. How can avoid this error?
>> Thanks.
>>
>>> El 21/02/2018, a las 18:29, Mike Walker <mike@advancedatatools.com>
>> escribió:
>>> Did you run the dbimport with the "-l" (lower case "L") to make sure that
> it
>>> was created with logging?
>>>
>>> If you did not, then the database would have been created with NO logging
>>> and would not be replicated over to the secondary server.
>>>
>>> Mike Walker
>>> Advanced DataTools Corporation
>>>
>>> -----Original Message-----
>>> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of jorge
>>> valenzuela
>>> Sent: Wednesday, February 21, 2018 7:16 PM
>>> To: ids@iiug.org
>>> Subject: Dbimport a database in an hdr [40727]
>>>
>>> Hi,
>>> I try to upload a databaae in an hdr environment using dbimport in the
>>> primary server. When it finish, I go to the secondary server but I cant
>>> access it. It say database doesn't found or no connect permission. How can
> I
>>> do to upload this database correctly?
>>>
>>> Thanks in advance.
>>>
>>>
> ****************************************************************************
>>> ***
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>>
>>>
>>
>
*******************************************************************************
>>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>>
>>
>>
>
*******************************************************************************
>> Forum Note: Use "Reply" to post a response in the discussion forum.
>>
>
> --
> Untitled Document
>
> *Ivan Zavi*
>
> /System Administrator/
>
> +381 21 68 98 608 | +381 69 846 99 08
>
> *M&I Systems, Co. Group*
>
> Bulevar vojvode Stepe 16, 21000 Novi Sad, Srbija
>
> +381 21 68 98 602 | +381 21 68 98 604
>
> info@mi-system.co.rs | www.mi-system.co.rs
>
> Odricanje od odgovornosti:
> Ovaj dokument namenjen je samo licima kojima je upucen i za pozivanje na
> isti od stane bilo kog lica, neophodna je naknadna pismena potvrda
> njegovog sadraja. Shodno tome, M&I Systems, Co. Novi Sad odrice svaku
> odgovornost i ne prihvata bilo kakvu obavezu (ukljucujuci slucaj
> nepanje) za posledice koje moe pretrpeti bilo koje lice zbog cinjenja
> ili necinjenja na bazi takve informacije pre nego to takva lica prime
> dodatnu pismenu potvrdu. Ukoliko ste grekom primili ovu elektronsku
> poruku, unitite ili izbriite istu sa vaeg racunara. Svako umnoavanje,
> irenje, kopiranje, obelodanjivanje, izmene, distribucija i/ili
> objavljivanje ove elektronske poruke je strogo zabranjeno. Sadraj ove
> elektronske poruke ne predstavlja nuno stavove M&I Systems, Co. Novi Sad
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>