IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

What is an ISPF table and why is it used for


IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Amb

New User


Joined: 12 Mar 2010
Posts: 64
Location: India

PostPosted: Tue Mar 23, 2010 4:41 pm
Reply with quote

Hi,

Can any one tell me
-what is an ISPF table and why is it used for?
-what is the difference between ISPF table and a DB2 table?
-How to view an ISPF table on mainframes?

Please let me know the answers for the above questions.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Tue Mar 23, 2010 4:56 pm
Reply with quote

-what is an ISPF table and why is it used for?
It is a table created using ISPF. It can be used for whatever the application designer wants to use it for

-what is the difference between ISPF table and a DB2 table?
Theorectically nothing, they are both tables. Just with different access methods.

-How to view an ISPF table on mainframes?
With the ISPF TBDISP command
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Mar 23, 2010 5:10 pm
Reply with quote

see
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/ISPZPM61
Back to top
View user's profile Send private message
Pedro

Global Moderator


Joined: 01 Sep 2006
Posts: 2546
Location: Silicon Valley

PostPosted: Tue Mar 23, 2010 7:40 pm
Reply with quote

-what is an ISPF table and why is it used for?
The main reason you would want to use an ISPF table is to be able to display it easily.

-what is the difference between ISPF table and a DB2 table?
As Expat said, they use different access methods. The old rule of thumb for ISPF tables was that you would get reasonable performance up to around 10,000 rows, but might get poor performance beyond that. I think DB2 tables can get significantly bigger.

-How to view an ISPF table on mainframes?
use the TBDISPL service. See ISPF Services Reference manual
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL

PostPosted: Tue Mar 23, 2010 8:08 pm
Reply with quote

Note that DB2 is a data base management system; there is no equivalent in ISPF, so if, say, two users are trying to update the same table simultaneously, handling the conflicts is entirely up to the code (and the coder).
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Tue Mar 23, 2010 8:18 pm
Reply with quote

Working with ISPF tables can produce very nice results, since they work well with ISPF Panels.

They can also be fustrating and difficult at times as well.

I do no reccomend that novices in TSO/ISPF/REXX programing take on the challenge, unless you are good at reading manuals, and good with rejection.

Coming here for ongoing help will prove to be difficult to get the desired results. It is all about trial and error and error and error.
Back to top
View user's profile Send private message
Amb

New User


Joined: 12 Mar 2010
Posts: 64
Location: India

PostPosted: Tue Mar 23, 2010 10:33 pm
Reply with quote

Thanks a lot guys for the quick response icon_smile.gif
Back to top
View user's profile Send private message
MBabu

Active User


Joined: 03 Aug 2008
Posts: 400
Location: Mumbai

PostPosted: Wed Mar 24, 2010 2:05 am
Reply with quote

Let me add one more thing... a general rule is that an ISPF table should not be used as a database. They are difficult to share, though it is possible) , there is no COMMIT/BACKOUT mechanism and they are only written to disk when they are closed, so an ISPF crash will lose changes. Performance is good because they are in storage, but don't use REXX and TBDISPL together for large tables (for reasons that are beyond the scope of the basic questions).

DB2 = Database
ISPF table = NOT database
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> TSO/ISPF

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Looking for a little history of ISPF ... TSO/ISPF 5
No new posts Adding QMF and SPUFI to the ISPF menu DB2 20
No new posts Multiple table unload using INZUTILB DB2 2
Search our Forums:

Back to Top