viewing tables on remote(aix) database in File Manager for



Ask queries about other IBM Tools like Tivoli, COBTEST, Fault Analyzer, z/OS File Manager, Workload Simulator, APA, SCLM, Merge & Migration Tools etc...

viewing tables on remote(aix) database in File Manager for

Postby gokulNmf » Fri Jun 29, 2012 9:57 pm

HI All,
I have been moved to a new project and only a small portion has MF in it, most are JAVA work. Now I face an issue:
My client has File Manager for DB2 to view/edit tables. As the application i wrk has tables on AIX and till now only java applications where accessing, now i some MF work related to them. I dont kow how to view them and what are the settings needed? No one in my project knows how to access it. :? :( :x
Can anyone hep me on this.Any info on this will be of great help.



Thanks in Advance.
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 118
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 2 times
Been thanked: 0 time

Re: viewing tables on remote(aix) database in File Manager f

Postby dick scherrer » Fri Jun 29, 2012 11:40 pm

Hello,

You need to talk with your databsae support and/or your network people. They know the configuration of your environments. We have no idea how the system is configured. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: viewing tables on remote(aix) database in File Manager f

Postby gokulNmf » Sat Jun 30, 2012 8:37 am

Hi Scherrer,
Thank you.. I ll do that.
But i always wonder, why ppl wrking on MF are always depend on Admins(either db,scheduler, z/os,... ) it make ppl look dull headed.. PPL on other tech knew almost all about the system they are wrking on... :(
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 118
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 2 times
Been thanked: 0 time

Re: viewing tables on remote(aix) database in File Manager f

Postby dick scherrer » Sat Jun 30, 2012 9:18 am

Hello,

it make ppl look dull headed.. PPL on other tech knew almost all about the system they are wrking on..
No, it is because most mainframes are professionaly managed and supported. There is an infrastructure that has been successful in every business environment i have ever seen or heard of. It is not unlike a professional football team (US style). Everyone has their position to learn and perform. This is true of coaches, managers, support people, etc.

Most developers on "other technology" know nearly nothing about the entire platform (especially Win-based systems). The MS goal was that they intended to be able to support those systems with "Users" rather than specialists. It should load out of the box and be immediately usable. And it is as long as the "stuff" is personal. The biggest failing of the MS environment is that the professional infrastructure is not there yet. Yes, some organizations have worked to implement a supportable environment, but many, many of the large attempts have failed.

One of the neat things about doing things on a Win-based system is that (if you have Admin priviledges) you can try almost anything you'd like to try. Not so on the mainframe (if it is at all well managed). If you take down "your" environment on the pc, not a big deal. If you find some way to take down a manframe, it gets Very Ugly.

Another big issue is the lack of standards on most Win-based systems. Good Standards, properly enforced are one of the biggest strengths of most mainframe environments. From what i see nearly everywhere "rolls their own" which makes hiring skilled Windows people problematic. So far there are few "industry standards" associated with the Windows environment.

There are many excellent offerings, but they don't all play well together. Some of the work i did over Y2K was to support the migration of several Mainframe applications to some purchased software. I was the Y2K remediation DBA for the mainframe and they needed someone to install and migrate the mainframe data to SQL Server. So i learned SQL Server. . . When we tried to run the purchased apps, they ran well individually. We found out quickly that a SQL Server DLL was needed (might have been sqlsrv32.dll :?: ). Unfortunately, these products needed different versions/releases of the DLL (and of cource as there wold only be one, they all had the same name).

To build a solid environment from scratch takes a very long time and will need specialists in several areas. Some of these are security, database, source code management, storage management, production promotions, system and application backups, disaster recovery plans, and on and on and on. . .

If you chose to stay in IT, this will become more understandable.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: viewing tables on remote(aix) database in File Manager f

Postby gokulNmf » Sat Jun 30, 2012 8:31 pm

Hi,
Thanks for the reply. I understood some, but not the whole(truly). As i am naive just 3 yrs into this Industry, it might take some more time to get experience of other tech as well(as you mentioned). And i have to agree with you as i studied like "mainframes are professionaly managed and supported".

Thank You.
Cheers,
Gokul
User avatar
gokulNmf
 
Posts: 118
Joined: Sat Mar 28, 2009 6:41 pm
Location: India
Has thanked: 2 times
Been thanked: 0 time

Re: viewing tables on remote(aix) database in File Manager f

Postby dick scherrer » Sun Jul 01, 2012 1:15 am

You're welcome :)

...just 3 yrs into this Industry, it might take some more time to get experience of other tech as well.
Yes, it does take time.

Good luck and someone will be here when you have questions.

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to Other IBM Tools

 


  • Related topics
    Replies
    Views
    Last post