Hi,
Let me just give a background of what the current process is before I proceed with my doubts.
Currently, I have a job in mainframes that is scheduled to run on a particular date and time every month(it is fully automated and no manual intervention is there in running that job).
I want to connect direct a xml file and a excel file each separately from unix system to another unix system.The size of the xml file and excel file may vary each time.
Below is the possible connect direct script to transfer the files.Please check if it is correct?
Also does DCB parameter required ?If required what should be the code for it?
==============
Code:
submit
do_copy process
Hi,
I have many scripts where i have used sftp for file transfer from unix box to unix box..
I want to connect to DB2 database which is mainframes using a unix script and run query and get the result set into the unix box.
Is this acheivable using db2 connect? pls help me with a sample script which can perform the same.
Hi,
We are using CA7 scheduler to trigger the jobs in UNIX. To check the status, we are opening the mainframe window and checking the status of the jobs. Is it possible to check the status from UNIX, so that we can automate this manual monitoring process?
I never used CA7 or mainframes before.
Thanks
Ajay
Important Unix Commands That You Should Know
By Bernard Peh
Unix is one of the most important operating system today. Its powerful features, scalability, strong security, and support for multiple users have made it the top choice operating systems for server, workstations and mainframes.
It is good to have some knowledge of Unix commands especially if your web host is Unix/Linux based.
I usually work in .NET and windows.But recently I have a problem which involves the unix server. The unix server is having text files whose data needs to be inserted to sql server database in another windows server. I need to insert the data on regular time interval of 15 mins automatically. I will be able to do the same by writing a windows services...but no idea in Unix..please help..
is there any way to automate the process of copiying the files between windows and unix
without doing it manually,using tools such as winscp.
I need to copy files from unix to windows such by executing some commands in windows.
i goolged it and found these tools that can do this.
ftp
sftp
scp
pscp
winscp console.
EDIT : can i get something using pscp beacase i just found out that ftp is not e
I am new to Putty, Unix and DB2 and this is what I am working on right now.
I installed Putty
I got access to username / pwd
I got Unix usrname/Pwd.also got the home directory
once I login into putty I get the screen and it shows $ sign
From here how do I connect to DB2 database?
I have tried db2 "connect to databasename"
but did not help
Please advise