International Informix Users Group

	Informix News

9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read 22 Mar 12 - developerWorks - Optimizing Informix database access... Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read 1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read 1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read 26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read 24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read 6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Read 2 Feb 12 - developerWorks - Loading data with the IBM Informix TimeSeries Plug-in for Data Studio... Read 1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... Read 13 Jan 12 - MC Press online - Informix Dynamic Server Entices New Users with Free Production Edition ... Read 11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Read 9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... Read 8 Sep 11 - TMCnet.com - IBM Offers Database Solution to Enable Smart Meter Data Capture... Read 1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... Read 8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix... Read 31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read 27 May 11 - IBM Data Management Magazine - IIUG user view: Big data, big time ( Series data, warehouse acceleration, and 4GLs )... Read 16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix. Log-based Change Data Capture... Read 21 Mar 11 - Yahoo! Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... Read 14 Mar 11 - MarketWatch - Fuzzy Logix and IBM Unveil In-Database Analytics for IBM Informix... Read 11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Read 9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... Read 2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... Read 27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Read 25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... Read 12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read 20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... Read 20 Jul 10 - IBM Announcements - IBM Informix Choice Edition V11.50 helps deploy low-cost scalable and reliable solutions for Apple Macintosh and Microsoft Windows... Read 20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Read 24 May 10 - eWeek Europe - IBM Supplies Database Tech For EU Smart Grid... Read 23 May 10 - SiliconIndia - IBM's smart metering system allows wise use of energy... Read 21 May 10 - CNET - IBM to help people monitor energy use... Read 20 May 10 - ebiz - IBM Teams With Hildebrand To Bring Smart Metering To Homes Across Britain... Read 19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read 19 May 10 - ZDNet - IBM software in your home? Pact enables five-city smart meter pilot in Europe... Read 17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read 17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and Informix databases... Read 10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. How do they lure the college crowd?... Read Previous news items

End of Support Dates

IDS 11.10 - 30 Sep 2012 Subscribe to notifications

Home Member Area About IIUG Help

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

SAP Mix

RE: System Refresh Using Tivoli TDP/Onbar

Posted By: Rajasekaran, Rajesh
Date: Friday, 17 January 2003, at 9:33 a.m.

In Response To: RE: System Refresh Using Tivoli TDP/Onbar (Julio Porras )

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2BE34.B9B41980
Content-Type: text/plain;
charset="iso-8859-1"

Hi,
After the restore, ensure the following steps

1) Login to dbaccess by connecting to sysmaster database and rename PRD
database as SBX
2) Change the sqlhosts file setup such as servername,
hostname,servicename w.r.t. SBX.
3) Point the database related env. variables to SBX,ONCONFIG to SBX
onconfig.
Note: We keep the copies of SBX,PRD setup files and keep switching to
these files before & after refresh
to reduce change time
4) Shutdown and logout the telnet session.
5) Login and restart the database.

Hope this helps

Rajesh Rajasekaran
Informix Database Administrator
Forest Pharmaceuticals Inc.
314-493-7073 (Work)
314-322-3428 (Cell)
314-514-2457 (Home)

-----Original Message-----
From: Julio Porras [mailto:Julio.Porras@venalum.com.ve]
Sent: Friday, January 17, 2003 7:35 AM
To: sapmix@iiug.org
Subject: RE: System Refresh Using Tivoli TDP/Onbar [9]

And once you restore your production backup to your sandbox machine, how do
you tell the sandbox "IT" is not your production system but instead a copy
of it on another machine? How do you change it's name and all references to
the original production system, if there are any?

Julio Porras
Especialista de Sistemas
CVG Venalum
286-9506898
416-7985875

-----Original Message-----
From: Janusz Wojn.... [mailto:janusz.wojnarowicz@de.ibm.com]
Sent: Viernes, 17 de Enero de 2003 06:12 a.m.
To: sapmix@iiug.org
Subject: Re: System Refresh Using Tivoli TDP/Onbar [8]

Hallo Cathy,

You don't have to change to parameter but you have to register a new node
to server.
Login into server with dsmadmc and your admin account and password and do:

register node informix domain=standard

then you have to register the server name in dsm.opt file (can be in
/usr/tivoli/tsm/client/api/bin64)
like for example:

Servername tsm_informix

and register it into dsm.sys, like for example:

SErvername tsm_informix
COMMmetthod TCPip
TCPPort 1500
TCPServeraddress is0066 -> machine name where your TSM server runs !!!
nodename informix
PASSWORDACCESS generate -> it must be so because of onbar
PASSWORDDIR /etc/adsm
compression yes

I assume you have already installed TDP fo Informix. Then you have to setup
your environment:

setenv DSMI_DIR /usr/tivoli/tsm/client/api/bin64
setenv DSMI_LOG /home/informix/tsm_logdir
setenv DSMI_INF_DIR /usr/tivoli/tsm/client/informix/bin64
setenv DSMI_CONFIG /usr/tivoli/tsm/client/api/bin64/dsm.opt

Next step ist to edit your onconfig file and set a path to XBSA library:

BAR_BSALIB_PATH=/usr/tivoli/tsm/client/informix/bin64/bsashr10.o for AIX
64Bit, libTDPinf64.sl for HP-UX 64Bit

and then edit $INFORMIXDIR/etc/sm_versions file and create a line for TSM:
1|4.1.0|adsm|4

1 - must be so
4.1.0 - TSM API version.release.level
adsm - SM application name which is recognized by onbar
4 - TSM version

Regards
Janusz.

______________________________________________________________________
Janusz Wojnarowicz mailto:Janusz.Wojnarowicz@de.ibm.com
Development Engineer phone: ++49 6227 7 42755
IBM Informix Technology Center @ SAP fax: ++49 6227 7 47147
c/o SAP AG TechDev 05
Neurottstr. 16
D-69190 Walldorf

"Weick Cathy "

<cathy.weick@siem To: sapmix@iiug.org

ens.com> cc:

Sent by: Subject: System Refresh
Using Tivoli TDP/Onbar [7]
forum.subscriber@

iiug.org

16.01.2003 23:49

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C2BDB1.2BAC7A20
Content-Type: text/plain;
charset="iso-8859-1"

I need to rebuild a sandbox system using my current production database.
This is my first time doing this with TDP and I'm not sure how I point the
server manager to restore the production database backup to the sandbox
machine. I'm guessing that I have to change the nodename parameter in dsm
file, how is the question.

Can anyone give me some guidance?

Thanks

------_=_NextPart_001_01C2BDB1.2BAC7A20
Content-Type: text/html;
charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.50.4207.2601" name=GENERATOR></HEAD>
<BODY>
<DIV>I
need to
rebuild a sandbox system using my current production database.  This
is my
first time doing this with TDP and I'm not sure how I point the server
manager
to restore the production database backup to the sandbox machine.  I'm

guessing that I have to change the nodename parameter in dsm file, how is
the
question.  </DIV>
<DIV> </DIV>
<DIV>Can
anyone
give me some guidance? </DIV>
<DIV> </DIV>
<DIV>Thanks
</DIV></BODY></HTML>

------_=_NextPart_001_01C2BDB1.2BAC7A20--

------_=_NextPart_001_01C2BE34.B9B41980
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: System Refresh Using Tivoli TDP/Onbar [9] </TITLE>
</HEAD>
<BODY>

Hi,
  After the restore, ensure the following =
steps


   1) Login to dbaccess by connecting to =
sysmaster database and rename PRD database as SBX
    2) Change the sqlhosts file setup such =
as servername, hostname,servicename w.r.t. SBX.
    3) Point the database related env. =
variables to SBX,ONCONFIG to SBX onconfig.
        Note: We keep =
the copies of SBX,PRD setup files and keep switching to these files =
before & after refresh  
           &nb=
sp;        to reduce change =
time
    4) Shutdown and logout the telnet =
session.
    5) Login and restart the =
database.
  
 Hope this helps


Rajesh Rajasekaran
 Informix Database Administrator
 Forest Pharmaceuticals Inc.
 314-493-7073 (Work)
 314-322-3428 (Cell)
 314-514-2457 (Home) 

 

-----Original Message-----
 From: Julio Porras [<A =
HREF=3D"mailto:Julio.Porras@venalum.com.ve">mailto:Julio.Porras@venalum.=
com.ve</A>]
 Sent: Friday, January 17, 2003 7:35 AM
 To: sapmix@iiug.org
 Subject: RE: System Refresh Using Tivoli TDP/Onbar =
[9] 

 

And once you restore your production backup to your =
sandbox machine, how do
 you tell the sandbox "IT" is not your =
production system but instead a copy
 of it on another machine? How do you change it's =
name and all references to
 the original production system, if there are =
any?

 

Julio Porras
 Especialista de Sistemas
 CVG Venalum
 286-9506898
 416-7985875


-----Original Message-----
 From: Janusz Wojn.... [<A =
HREF=3D"mailto:janusz.wojnarowicz@de.ibm.com">mailto:janusz.wojnarowicz@=
de.ibm.com</A>] 
 Sent: Viernes, 17 de Enero de 2003 06:12 a.m.
 To: sapmix@iiug.org
 Subject: Re: System Refresh Using Tivoli TDP/Onbar =
[8] 


Hallo Cathy,


You don't have to change to parameter but you have to =
register a new node
 to server.
 Login into server with dsmadmc and your admin =
account and password and do:


register node informix domain=3Dstandard


then you have to register the server name in dsm.opt =
file (can be in
 /usr/tivoli/tsm/client/api/bin64)
 like for example:


Servername tsm_informix


and register it into dsm.sys, like for =
example:


SErvername        =
tsm_informix
 COMMmetthod       =
TCPip
 TCPPort         &n=
bsp; 1500
 TCPServeraddress  is0066   -> =
machine name where your TSM server runs !!!
 nodename          =
informix
 PASSWORDACCESS    generate -> it =
must be so because of onbar
 PASSWORDDIR /etc/adsm
 compression       =
yes


I assume you have already installed TDP fo Informix. =
Then you have to setup
 your environment:


setenv DSMI_DIR   =
/usr/tivoli/tsm/client/api/bin64
 setenv DSMI_LOG   =
/home/informix/tsm_logdir
 setenv DSMI_INF_DIR     =
/usr/tivoli/tsm/client/informix/bin64
 setenv DSMI_CONFIG      =
/usr/tivoli/tsm/client/api/bin64/dsm.opt


Next step ist to edit your onconfig file and set a =
path to XBSA library:


BAR_BSALIB_PATH=3D/usr/tivoli/tsm/client/informix/bin64/bsashr1=
0.o for AIX
 64Bit, libTDPinf64.sl for HP-UX 64Bit


and then edit  $INFORMIXDIR/etc/sm_versions file =
and create a line for TSM:
 1|4.1.0|adsm|4


1 - must be so
 4.1.0 - TSM API version.release.level
 adsm - SM application name which is recognized by =
onbar
 4 - TSM version

 
 

Regards
 Janusz.


_______________________________________________________________=
_______
 Janusz =
Wojnarowicz          &=
nbsp;       <A =
HREF=3D"mailto:Janusz.Wojnarowicz@de.ibm.com">mailto:Janusz.Wojnarowicz@=
de.ibm.com</A>
 Development =
Engineer          &nbs=
p;     phone:      ++49 =
6227 7 42755
 IBM Informix Technology Center @ =
SAP      fax:  ++49 6227 7 47147
 c/o SAP AG TechDev 05
 Neurottstr. 16
 D-69190 Walldorf

 
 

 


          &nb=
sp;           =
"Weick Cathy "


          &nb=
sp;           =
<cathy.weick@siem        =
To:       sapmix@iiug.org


          &nb=
sp;           =
ens.com>          &=
nbsp;      cc:


          &nb=
sp;           Sent =
by:           &nb=
sp;     Subject:  System Refresh
 Using Tivoli TDP/Onbar =
[7]           &nb=
sp;           &nb=
sp;           &nb=
sp; 
         &nbsp=
;           &nbsp=
; forum.subscriber@


          &nb=
sp;           =
iiug.org


 


 


          &nb=
sp;           =
16.01.2003 23:49


 

 
 
 

This message is in MIME format. Since your mail =
reader does not understand
 this format, some or all of this message may not be =
legible.


------_=3D_NextPart_001_01C2BDB1.2BAC7A20
 Content-Type: text/plain;
           &nb=
sp;  charset=3D"iso-8859-1"


I need to rebuild a sandbox system using my current =
production database.
 This is my first time doing this with TDP and I'm =
not sure how I point the
 server manager to restore the production database =
backup to the sandbox
 machine.  I'm guessing that I have to change =
the nodename parameter in dsm
 file, how is the question.


Can anyone give me some guidance?


Thanks


------_=3D_NextPart_001_01C2BDB1.2BAC7A20
 Content-Type: text/html;
           &nb=
sp;  charset=3D"iso-8859-1"


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 =
Transitional//EN">
 <HTML><HEAD>
 <META HTTP-EQUIV=3D"Content-Type" =
CONTENT=3D"text/html; charset=3Diso-8859-1">

 

<META content=3D"MSHTML 5.50.4207.2601" =
name=3DGENERATOR></HEAD>
 <BODY>
 <DIV>I
 need to
 rebuild a sandbox system using my current production =
database.&nbsp; This
 is my
 first time doing this with TDP and I'm not sure how =
I point the server
 manager
 to restore the production database backup to the =
sandbox machine.&nbsp; I'm


guessing that I have to change the nodename parameter =
in dsm file, how is
 the
 question.&nbsp; =
</DIV>
 <DIV>
 size=3D2>&nbsp;</DIV></F=
ONT>
 <DIV>Can
 anyone
 give me some =
guidance?&nbsp;</DIV>
 <DIV>
 size=3D2>&nbsp;</DIV></F=
ONT>
 <DIV>
 size=3D2>Thanks
 </DIV></BODY></HTML&gt=
;


------_=3D_NextPart_001_01C2BDB1.2BAC7A20--

 
 
 

</BODY>
</HTML>
------_=_NextPart_001_01C2BE34.B9B41980--

Messages In This Thread

System Refresh Using Tivoli TDP/Onbar
Weick Cathy -- Thursday, 16 January 2003, at 5:49 p.m.
- Re: System Refresh Using Tivoli TDP/Onbar
  Janusz Wojnarowicz -- Friday, 17 January 2003, at 5:11 a.m.
  - RE: System Refresh Using Tivoli TDP/Onbar
    Julio Porras -- Friday, 17 January 2003, at 8:35 a.m.
    - RE: System Refresh Using Tivoli TDP/Onbar
      Rajasekaran, Rajesh -- Friday, 17 January 2003, at 9:33 a.m.
  - RE: System Refresh Using Tivoli TDP/Onbar
    Janusz Wojnarowicz -- Friday, 17 January 2003, at 9:05 a.m.

[ View Thread ] [ Post Response ] [ Return to Index ] [ Read Prev Msg ] [ Read Next Msg ]

SAP Mix is maintained by Administrator with WebBBS 5.12.