| View previous topic :: View next topic |
| Author |
Message |
raam_narayan
Beginner
Joined: 28 Apr 2006
Posts: 12
Topics: 2
|
 Posted: Tue May 02, 2006 5:22 am Post subject: Issue while moving DB2 Table.. |
 |
|
HI,
Can anybody tell me what are all the Parameters i.e. ( including the DB2 Master Catalog ) we should take care when moving the DB2 Table from the Development region towards the production Region.. Appreciating the quick reply...
Thanks & Regards,
V.Ram NArayan |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue May 02, 2006 5:29 am Post subject: |
|
|
raam_narayan,
Move a Db2 table? Isn't it as simple as this ?
1. Create the table on the production using the same DDL as in test
2. Unload the data from test tables
3. FTP/NDM the data to production
4. Load the table on production.
That's all
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
shekar123
Advanced
Joined: 22 Jul 2005
Posts: 528
Topics: 90
Location: Bangalore India
|
| Posted: Tue May 02, 2006 7:43 am Post subject: |
|
|
Kolusu,
Suppose i have a table A in development region and i unload the DB2 table data to a dataset say SHEKAR.DEV.TABLE.
Can you please tell me how do i do FTP/NDM the data present in the dataset SHEKAR.DEV.TABLE to prod.I am unware of the process of the FTP/NDM and i understand that we can load the data to a DB2 table from a dataset using the LOAD utility?
However,I have no knowledge of the FTP/NDM process , please help me out as how can we do it ?
_________________
Shekar
Grow Technically |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Tue May 02, 2006 8:41 am Post subject: |
|
|
| Quote: |
Can you please tell me how do i do FTP/NDM the data present in the dataset SHEKAR.DEV.TABLE to prod.I am unware of the process of the FTP/NDM and i understand that we can load the data to a DB2 table from a dataset using the LOAD utility?
|
Shekhar123,
You need to know the IP address of your mainframe before you can FTP. you can find the IP address of your mainframe with the following rexx exec
http://www.mvsforums.com/helpboards/viewtopic.php?p=15218#15218
Once you have IP address then it is very easy. Open DOS prompt and type
It prompts for user and password then you issue the regular FTP commands(provided that your user id has the FTP privileges)
NDM(Network data mover) is a 3rd party tool which is used to transfer files. So if your shop has it it is better to ask your co-workers.
if the files are small you can also use XMIT aka TRANSMIT command to transmit files. Check this link which explains in detail.
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IKJ4C531/1.96?DT=20021022140245
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
