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

When the table was last updated


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Mon Jul 20, 2015 11:13 am
Reply with quote

Hello All

Is there any way we can find out when the DB2 table was last updated without contacting the admins via some query etc
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


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

PostPosted: Mon Jul 20, 2015 3:48 pm
Reply with quote

No.
Back to top
View user's profile Send private message
vickey_dw

New User


Joined: 10 Jun 2015
Posts: 51
Location: India

PostPosted: Mon Jul 20, 2015 4:23 pm
Reply with quote

Quote:
No.

icon_sad.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Mon Jul 20, 2015 11:33 pm
Reply with quote

I wonder why people use the forums to find how to do things without involving the proper <in house> support groups ???
Back to top
View user's profile Send private message
rikdeb

New User


Joined: 19 Jan 2009
Posts: 63
Location: hyderabad

PostPosted: Mon Jul 20, 2015 11:44 pm
Reply with quote

Exactly not sure if this will help, but there are some columns in SYSIBM.SYSCOPY which can provide you the timestamp when a row gets updated. Have a look if this helps or any other solution if you got any.

www-304.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.sqlref/src/tpc/db2z_sysibmsyscopytable.dita?cp=SSEPEK_10.0.0%2F10-0-30
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Mon Jul 20, 2015 11:48 pm
Reply with quote

Quote:
I wonder why people use the forums to find how to do things without involving the proper <in house> support groups ???


It is because they "don't know" that how much is it that they "should know" and then they don't wanna feel embarassed in front of the support group for something they should have known.

.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA

PostPosted: Tue Jul 21, 2015 12:56 am
Reply with quote

Don't you have a timestamp column? if not then that is bad.

or look for BMC logmaster, DB2 Log Analysis tool
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Tue Jul 21, 2015 1:38 am
Reply with quote

Quote:
It is because they "don't know" that how much is it that they "should know" and then they don't wanna feel embarassed in front of the support group for something they should have known.

the most stupid reason I ever heard about.

before asking the support group, they should ask the working group responsible, who ( unless a complete moron ) should know the skill level of his subordinates and what to expect from them.

and ...
what about being reprimanded/terminated for attempting to do something that they should not have done because some so called expert told them how to do it ?
( seen it too many times for security related questions )
icon_evil.gif

unfortunately the current forum philosophy/mentality is to make the TS happy just caring about the lowly technicalities , disregarding completely the practices that might be in place

and since we DO NOT belong to the TS organisation we do know absolutely nothing about them

and while the answer might be lowly right it might be misplace for the TS organisation standards.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


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

PostPosted: Tue Jul 21, 2015 3:49 pm
Reply with quote

enrico-sorichetti wrote:
what about being reprimanded/terminated for attempting to do something that they should not have done because some so called expert told them how to do it ?
( seen it too many times for security related questions )
icon_evil.gif

unfortunately the current forum philosophy/mentality is to make the TS happy just caring about the lowly technicalities , disregarding completely the practices that might be in place

As a borderline sociopath I consider this an example pour encourager les autres icon_evil.gif
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 -> DB2

 


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 Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top