Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is an ISPF table and why is it used for

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
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    Post subject: What is an ISPF table and why is it used for
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: 8593
Location: Back in jolly old England

PostPosted: Tue Mar 23, 2010 4:56 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Tue Mar 23, 2010 5:10 pm    Post subject: Reply to: ISPF table
Reply with quote

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

Senior Member


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

PostPosted: Tue Mar 23, 2010 7:40 pm    Post subject: Reply to: ISPF table
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: 1755
Location: Bloomington, IL

PostPosted: Tue Mar 23, 2010 8:08 pm    Post subject:
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: 662
Location: Pennsylvania

PostPosted: Tue Mar 23, 2010 8:18 pm    Post subject:
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    Post subject: Reply to: What is an ISPF table and why is it used for
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: 401
Location: Mumbai

PostPosted: Wed Mar 24, 2010 2:05 am    Post subject:
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    IBMMAINFRAMES.com Support Forums -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts Customizing the ISPF HILITE Command Pedro TSO/ISPF 3 Fri Mar 03, 2017 11:49 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts ISPF - How to come out of ISPF Panel parasmalik20 TSO/ISPF 5 Tue Feb 21, 2017 7:44 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us