Yes its possible. The format.conv command has -export, -import, -delete and other options to allow you to accomplish the moving of SQL schemas (each project is a schema). You can NOT do it successfully simply by using operating system commands. Seek assistance.
As to the performance impact, how long is a piece of string? Will extra disk space help on the production system? Only if youre really short of it. Will less contention for disk resources help on the production system? Maybe, assuming the dev and test systems are not still hitting the disks on the production system for access to databases. Will the production system be faster? Probably not - depends where the bottleneck was. Will the dev and test systems be faster? Probably not - depends where their bottlenecks are, and whether youre introducing extra bottlenecks, such as the network, that were not present earlier. So how long is that piece of string?
-----Original Message-----
From: kuan@clear.net.nz [mailto:kuan@clear.net.nz]
Sent: Thursday, 01 November 2001 09:31
To: datastage-users@oliver.com
Subject: Setting Up Projects Across Servers
Hi All
I wonder if this is possible. Currently, we have datastage and three projects (dev, test, prod) all residing on one server. We are thinking of moving or recreating dev and test on another server. The idea is to have production running on one server and development and QA on another and to recover disk space from the production server.
We are running DS 4.0.2 on Solaris 2.6. If this is possible, I wonder if performance would be severely impacted.
TIA
Hong
Setting Up Projects Across Servers
Setting Up Projects Across Servers
Hi All
I wonder if this is possible. Currently, we have datastage and three projects (dev, test, prod) all residing on one server. We are thinking of moving or recreating dev and test on another server. The idea is to have production running on one server and development and QA on another and to recover disk space from the production server.
We are running DS 4.0.2 on Solaris 2.6. If this is possible, I wonder if performance would be severely impacted.
TIA
Hong
I wonder if this is possible. Currently, we have datastage and three projects (dev, test, prod) all residing on one server. We are thinking of moving or recreating dev and test on another server. The idea is to have production running on one server and development and QA on another and to recover disk space from the production server.
We are running DS 4.0.2 on Solaris 2.6. If this is possible, I wonder if performance would be severely impacted.
TIA
Hong
Yes, but I wouldnt delete the original till Id tested the new version! ![Smile :)](./images/smilies/icon_smile.gif)
-----Original Message-----
From: kuan@clear.net.nz [mailto:kuan@clear.net.nz]
Sent: Thursday, 01 November 2001 10:54
To: datastage-users@oliver.com
Subject: RE: Setting Up Projects Across Servers
Thanks Ray.
Would export of whole project to dsx, delete project, create project in target server, import project from dsx achieve the same thing? Most if not all of our hash and universe tables are create on demand.
>Yes its possible. The format.conv command has -export, -import,
>-delete and other options to allow you to accomplish the moving of SQL
>schemas
(each
>project is a schema). You can NOT do it successfully simply by using
>operating system commands. Seek assistance.
>
>As to the performance impact, how long is a piece of string? Will
>extra disk space help on the production system? Only if youre really
>short of it. Will less contention for disk resources help on the
>production system?
>Maybe, assuming the dev and test systems are not still hitting the
>disks on
>the production system for access to databases. Will the production
>system
>be faster? Probably not - depends where the bottleneck was. Will the
>dev
>and test systems be faster? Probably not - depends where their
>bottlenecks
>are, and whether youre introducing extra bottlenecks, such as the
>network,
>that were not present earlier. So how long is that piece of string?
>
>-----Original Message-----
>From: kuan@clear.net.nz [mailto:kuan@clear.net.nz]
>Sent: Thursday, 01 November 2001 09:31
>To: datastage-users@oliver.com
>Subject: Setting Up Projects Across Servers
>
>
>Hi All
>
>I wonder if this is possible. Currently, we have datastage and three
>projects (dev, test, prod) all residing on one server. We are thinking
>of moving or
>recreating
>dev and test on another server. The idea is to have production running
>on one server and development and QA on another and to recover disk
>space from the
>production server.
>
>We are running DS 4.0.2 on Solaris 2.6. If this is possible, I wonder
>if performance would be severely impacted.
>
>TIA
>Hong
>
>
>
![Smile :)](./images/smilies/icon_smile.gif)
-----Original Message-----
From: kuan@clear.net.nz [mailto:kuan@clear.net.nz]
Sent: Thursday, 01 November 2001 10:54
To: datastage-users@oliver.com
Subject: RE: Setting Up Projects Across Servers
Thanks Ray.
Would export of whole project to dsx, delete project, create project in target server, import project from dsx achieve the same thing? Most if not all of our hash and universe tables are create on demand.
>Yes its possible. The format.conv command has -export, -import,
>-delete and other options to allow you to accomplish the moving of SQL
>schemas
(each
>project is a schema). You can NOT do it successfully simply by using
>operating system commands. Seek assistance.
>
>As to the performance impact, how long is a piece of string? Will
>extra disk space help on the production system? Only if youre really
>short of it. Will less contention for disk resources help on the
>production system?
>Maybe, assuming the dev and test systems are not still hitting the
>disks on
>the production system for access to databases. Will the production
>system
>be faster? Probably not - depends where the bottleneck was. Will the
>dev
>and test systems be faster? Probably not - depends where their
>bottlenecks
>are, and whether youre introducing extra bottlenecks, such as the
>network,
>that were not present earlier. So how long is that piece of string?
>
>-----Original Message-----
>From: kuan@clear.net.nz [mailto:kuan@clear.net.nz]
>Sent: Thursday, 01 November 2001 09:31
>To: datastage-users@oliver.com
>Subject: Setting Up Projects Across Servers
>
>
>Hi All
>
>I wonder if this is possible. Currently, we have datastage and three
>projects (dev, test, prod) all residing on one server. We are thinking
>of moving or
>recreating
>dev and test on another server. The idea is to have production running
>on one server and development and QA on another and to recover disk
>space from the
>production server.
>
>We are running DS 4.0.2 on Solaris 2.6. If this is possible, I wonder
>if performance would be severely impacted.
>
>TIA
>Hong
>
>
>
Thanks Ray.
Would export of whole project to dsx, delete project, create project in target server, import project from dsx achieve the same thing? Most if not all of our hash and universe tables are create on demand.
>Yes its possible. The format.conv command has -export, -import,
>-delete and other options to allow you to accomplish the moving of SQL
>schemas (each
>project is a schema). You can NOT do it successfully simply by using
>operating system commands. Seek assistance.
>
>As to the performance impact, how long is a piece of string? Will
>extra disk space help on the production system? Only if youre really
>short of it. Will less contention for disk resources help on the
>production system?
>Maybe, assuming the dev and test systems are not still hitting the
>disks on
>the production system for access to databases. Will the production
>system
>be faster? Probably not - depends where the bottleneck was. Will the
>dev
>and test systems be faster? Probably not - depends where their
>bottlenecks
>are, and whether youre introducing extra bottlenecks, such as the
>network,
>that were not present earlier. So how long is that piece of string?
>
>-----Original Message-----
>From: kuan@clear.net.nz [mailto:kuan@clear.net.nz]
>Sent: Thursday, 01 November 2001 09:31
>To: datastage-users@oliver.com
>Subject: Setting Up Projects Across Servers
>
>
>Hi All
>
>I wonder if this is possible. Currently, we have datastage and three
>projects (dev, test, prod) all residing on one server. We are thinking
>of moving or
>recreating
>dev and test on another server. The idea is to have production running
>on one server and development and QA on another and to recover disk
>space from the
>production server.
>
>We are running DS 4.0.2 on Solaris 2.6. If this is possible, I wonder
>if performance would be severely impacted.
>
>TIA
>Hong
>
>
>
Would export of whole project to dsx, delete project, create project in target server, import project from dsx achieve the same thing? Most if not all of our hash and universe tables are create on demand.
>Yes its possible. The format.conv command has -export, -import,
>-delete and other options to allow you to accomplish the moving of SQL
>schemas (each
>project is a schema). You can NOT do it successfully simply by using
>operating system commands. Seek assistance.
>
>As to the performance impact, how long is a piece of string? Will
>extra disk space help on the production system? Only if youre really
>short of it. Will less contention for disk resources help on the
>production system?
>Maybe, assuming the dev and test systems are not still hitting the
>disks on
>the production system for access to databases. Will the production
>system
>be faster? Probably not - depends where the bottleneck was. Will the
>dev
>and test systems be faster? Probably not - depends where their
>bottlenecks
>are, and whether youre introducing extra bottlenecks, such as the
>network,
>that were not present earlier. So how long is that piece of string?
>
>-----Original Message-----
>From: kuan@clear.net.nz [mailto:kuan@clear.net.nz]
>Sent: Thursday, 01 November 2001 09:31
>To: datastage-users@oliver.com
>Subject: Setting Up Projects Across Servers
>
>
>Hi All
>
>I wonder if this is possible. Currently, we have datastage and three
>projects (dev, test, prod) all residing on one server. We are thinking
>of moving or
>recreating
>dev and test on another server. The idea is to have production running
>on one server and development and QA on another and to recover disk
>space from the
>production server.
>
>We are running DS 4.0.2 on Solaris 2.6. If this is possible, I wonder
>if performance would be severely impacted.
>
>TIA
>Hong
>
>
>