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
 

 

Tables in Tablebase library?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools
View previous topic :: :: View next topic  
Author Message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Fri Apr 04, 2008 11:16 am    Post subject: Tables in Tablebase library?
Reply with quote

Hi,
How can i get the list of tables (with table definition) present in a tablebase library. Can any one please say which utility we have to use and also can any one please give me the syntax for this.


Thanks,
Sujesh.
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: Fri Apr 04, 2008 1:13 pm    Post subject:
Reply with quote

Are we talking ISPF tables, DB2 tables ...... blah blah .............. tables ???
Back to top
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Fri Apr 04, 2008 1:42 pm    Post subject: Reply to: Tables in Tablebase library?
Reply with quote

No... It is different from DB2 table...tableBASE is a software tool for reducing the I/O and CPU overhead in mainframe (z/OS
and OS/390) applications. It is a product of data kinetics.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Fri Apr 04, 2008 8:31 pm    Post subject:
Reply with quote

Quote:
list of tables (with table definition) present in a tablebase library
Do you have tablebase menu options? in that there is utility and under that PRINT option is available. Can you check that?
Back to top
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Sat Apr 05, 2008 12:11 pm    Post subject: Reply to: Tables in Tablebase library?
Reply with quote

Hi Devzee,
There is an option called tablebase online. But i need to run this daily after a particular job ends, so i felt that it will be better to write a batch job to get the details as soon as the job ends (and mail them to concerned person, with a mailing step in the job). I have asked for some documents from data kinetics, but i have not yet received any reply from them. Is there any batch utility which can get the details (table names and definition). If possible can you get the syntax?Thanks in advance.


Thanks,
Sujesh.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Sun Apr 06, 2008 1:42 am    Post subject:
Reply with quote

Do you want to run this table base listing daily? Why? Are there new tables created daily?
There are batch utilities but I dont remember if it can print all the table names and table definitions.
Back to top
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Tue Apr 08, 2008 8:12 am    Post subject: Reply to: Tables in Tablebase library?
Reply with quote

Hi Devzee,
I need to run this weekly once (every saturday). This is because almost all the tables are geting deleted and recreated and also there are few new tables that are getting created, hence the users want to check if the table definition is fine (for old and the new once). The library will have around 300 tables. Can you please tell me the batch utility and their syntax? Thanks in advance.


Thanks,
Sujesh.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Apr 08, 2008 11:48 am    Post subject:
Reply with quote

Let me check.
Back to top
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Thu Apr 10, 2008 2:19 pm    Post subject: Reply to: Tables in Tablebase library?
Reply with quote

Hi,
By using the utility 'TBDEFPRT' iam able to get the details of all the tables (along with definition) in the tablebase library.But this also displays the table view. Is there any way we can suppress the view details from being displayed.


Thanks,
Sujesh.
Back to top
View user's profile Send private message
JayC

New User


Joined: 27 Sep 2008
Posts: 70

PostPosted: Wed Nov 12, 2008 10:29 am    Post subject:
Reply with quote

Hi Sujesh,

Do you mind sharing this utility TBDEFPRT ? If its not too much of a trouble? The syntax and how it works ?

Thanks.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Nov 12, 2008 11:42 am    Post subject:
Reply with quote

Hi,

it's been a while when Sujesh last posted, I believe he will not be back soon. If you have tool available at your shop check with the documentation about the utility in question, I tried to search a lil but didn't find a good reference material.
Back to top
View user's profile Send private message
passion_sujesh

New User


Joined: 14 Mar 2008
Posts: 74
Location: India,Chennai

PostPosted: Fri Mar 20, 2009 8:47 am    Post subject: Reply to: Tables in Tablebase library?
Reply with quote

Hi,
Sorry for the very late reply, Guess this might help u in near future.

Code:
//STEP00    EXEC PGM=TBDEFPRT                                 
//SYSPRINT DD SYSOUT=*                                       
//TBDUMP   DD SYSOUT=*                                       
//SYSOUT   DD SYSOUT=*                                       
//TBRPT    DD SYSOUT=*                                       
//SORTMSGS DD SYSOUT=*                                       
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(5,1))                   
//SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(5,1))                   
//SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(5,1))                   
//SORTWK04 DD UNIT=SYSDA,SPACE=(CYL,(5,1))                   
//SORTWK05 DD UNIT=SYSDA,SPACE=(CYL,(5,1))                   
//LIB1 DD DISP=SHR,DSN=***.TBLBASE.LIBRARY   
//COMMAND DD *                                               
      FROMDDN=LIB1;                                           
/*                                                           
//*               

This will display the definition of all the table present in the tablebase library.

Thanks,
Sujesh.

Edited: Please use BBcode when You post some code/error, that's rather readable, Thanks... Anuj
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 -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting list of tables defined under ... kishpra DB2 2 Wed Aug 24, 2016 10:36 am
No new posts ISPF Tables Creation newsysprg TSO/ISPF 6 Wed Jul 13, 2016 2:21 pm
No new posts how to find clist's or view library Andrew Hsia CLIST & REXX 4 Tue Jun 28, 2016 6:07 pm
No new posts New DB2 tables creation kishpra DB2 3 Tue Feb 02, 2016 7:00 pm
No new posts Syntax to create new tableBASE library Sumeendar IBM Tools 1 Tue Sep 15, 2015 6:25 pm


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