MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Bind version

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
monaco
Beginner


Joined: 20 May 2004
Posts: 77
Topics: 31

PostPosted: Thu Feb 17, 2005 10:19 am    Post subject: Bind version Reply with quote

Hi all,

we'd like to keep only two bind version per program. We dont know exactly which parameters we need to have in the compilation processor.

We tryied with VERSION(2) instead of VERSION(AUTO) but we dont get the new version replace the old one.

Any idea?


Thanks a lot
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose

PostPosted: Thu Feb 17, 2005 11:04 am    Post subject: Reply with quote

Monaco,

Did you have the ACTION(REPLACE) keyword on your bind card?

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
monaco
Beginner


Joined: 20 May 2004
Posts: 77
Topics: 31

PostPosted: Thu Feb 17, 2005 11:36 am    Post subject: Reply with quote

Thanks Kolusu for your answer but we are looking for the way to keep to versions. If we execute a bind we replace the old one and still we have two version.
Is there a way to delimit the number of versions?

Thanks
Back to top
View user's profile Send private message
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Fri Feb 18, 2005 7:35 am    Post subject: Reply with quote

The bind process has no means to delimit the number of versions to be kept in the catalog. You have to issue FREE PACKAGE commands for those packages you don't need.
In our house we have a rexx procedure looking into the catalog and retrieving all unwanted version ids. For those a free package jcl is created and submitted.

regards
Christian
Back to top
View user's profile Send private message
monaco
Beginner


Joined: 20 May 2004
Posts: 77
Topics: 31

PostPosted: Thu Mar 03, 2005 4:03 am    Post subject: Reply with quote

Hi CZerfas,

is there any chance you can send me that process?

Thanks a lot.
Back to top
View user's profile Send private message
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Thu Mar 03, 2005 5:02 am    Post subject: Reply with quote

Hello Monaco,

since I don't know how to use attatchments in this forum, I need your email address to send it directly to you.

regards
Christian
Back to top
View user's profile Send private message
monaco
Beginner


Joined: 20 May 2004
Posts: 77
Topics: 31

PostPosted: Thu Mar 03, 2005 5:08 am    Post subject: Reply with quote

Thanks a lot.

My address is:
david.san.servando@accenture.com

Thanks a million.
Back to top
View user's profile Send private message
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Thu Mar 03, 2005 9:14 am    Post subject: Reply with quote

Hello Monaco,

looking into the procedure I discovered, that too many site specifica are included to make the process useful for you.

The idea is, that you have to know the dbrm libraries, whose members are bound to your db2 tables. In the dbrms you find the consistancy tokens, with which you can make the connection to the data in SYSPACKAGE. With these informations you can identify all db2 packages, for which no dbrm is available any more.

These are the candidates for FREE PACKAGE commands.

Special consideration can be applied to NCALL modules. Those are excluded from the automated house-keeping in our shop.

regards
Christian
Back to top
View user's profile Send private message
monaco
Beginner


Joined: 20 May 2004
Posts: 77
Topics: 31

PostPosted: Thu Mar 03, 2005 9:50 am    Post subject: Reply with quote

Thanks a lot.
Back to top
View user's profile Send private message
monaco
Beginner


Joined: 20 May 2004
Posts: 77
Topics: 31

PostPosted: Tue Apr 19, 2005 11:08 am    Post subject: Reply with quote

Hi all,

after long time i come back with the FREE PACKAGE issue.

Could someone provide me an example about how to get the consistancy tokens from the DBRM library?
We think to use a REXX but it takes ages.

Thanks a lot.

Kind regards.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose

PostPosted: Tue Apr 19, 2005 6:31 pm    Post subject: Reply with quote

Quote:

Could someone provide me an example about how to get the consistancy tokens from the DBRM library?
We think to use a REXX but it takes ages.


Monaco,

DBRM Checker is available from IBM as part of Bind Manager. This will check/convrt the DBRM timestamp to a readable format.

There are rexx exec available on the internet to convert the dbrm timestamp to a readable format. You can try converting them to a programming language like assembler or Cobol

Check these links

http://www.mainframeweek.com/journals/articles/0009/102

http://www.ruban.de/DB2_UDB_for_z_OS/z_OS_Code/DB2_z_OS_Code_-_Detail_View/db2_z_os_code_-_detail_view_6.html


Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group