How do you know the last date/time update stats is run on a table?

regards,
Abel


0
Abel
6/26/2001 5:54:21 AM
sybase.ase.general 8655 articles. 0 followers. Follow

2 Replies
9125 Views

Similar Articles

[PageSpeed] 43

The nitty-gritty is in sysstatistics.   An SP that generates the output
below is my sp_newstats proc in the dba.sql file at

http://www.bossconsulting.com/sybase_dba/

However you better read the Installation Guide first since other procs also
have to be loaded.  A quicker way would be to use the code and strip off the
execution of sp_date, etc. that prettyprints the dates.


sp_newstats


 CURRENT DATE/TIME
 --------------------------------
 May 6, 2001 (08:40:53 AM)

    THERE ARE 48 STATISTICS ROWS FOR 9 SYSTEM TABLES IN systatistics.

    THERE ARE 46 STATISTICS ROWS FOR 17 USER TABLES IN systatistics.

 TABLE (COLUMNS)         CREATE/MODIFY  STEPS
 ----------------------------- --------------               -----
 trkreg (regEntry)                   01/05/06 08:36                20
 trkreg (regId)                        01/05/06 08:36              182
 trkreg (regSection)                01/05/06 08:36                28
 trkreg (regSection, regEntry) 01/05/06 08:36                   -
 sysindexes (id)                      01/05/06 08:37                 92
 sysindexes (id, indid)             01/05/06 08:37                  -
 sysindexes (indid)                  01/05/06 08:37                13






Abel de Guzman <abeld@concorde.com.au> wrote in message
news:MzX6vcg$AHA.301@forums.sybase.com...
> regards,
> Abel
>
>


0
Carl
6/26/2001 12:31:17 PM
Provided you are running ASE 11.9 or later, the following query will
give you the answer:

select moddate from sysstatistics where id =
object_id("your_table_name")

You can also use the optdiag tool, which displays a lot more
information but also these dates.

HTH,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.0/11.5/11.0

Author of "The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/qr

email mailto:rob@sypron.nl.*No*Spam*Please*
WWW  http://www.sypron.nl
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

"Abel de Guzman" <abeld@concorde.com.au> wrote in message
news:MzX6vcg$AHA.301@forums.sybase.com...
> regards,
> Abel
>
>

0
Rob
6/26/2001 8:19:53 PM
Reply:

Similar Artilces:

last time table updated
Hi, Does Sybase keep track or can it be configured to track a table's update (insert, update, delete) time without using the trigger ? Thanks. Gary ASE doesn't automatically keep track of this, but you can use either triggers or the auditing feature to track such activity. -bret Gary Fu wrote: > Hi, > > Does Sybase keep track or can it be configured to track a table's > update (insert, update, delete) time without using the trigger ? > > Thanks. > > Gary ...

please tell how to update date field in table whenever the table is updated
suppose that if i update my table like inserting a record or deleting a record, the date field in the table gets updated automatically assuming that you are using sql server you can use the sql statement: 'update set lastupdated=getdate() where primarykey=5' getdate is the function to get the time and date of the sql server....

How to find the status, i.e. "next run time" and "last run time", of a task which is run through windows task scheduler !
--00c09f93d7653439de0488814544 Content-Type: text/plain; charset=ISO-8859-1 Hi all, I want to know how to find the status, i.e. "next run time" and "last run time", of a task which is run through windows task scheduler. This is required so as to find out instances where a task gets "hanged" after run through windows task scheduler. Thanks & Regards, Amit Saxena --00c09f93d7653439de0488814544-- On Tue, Jun 8, 2010 at 05:18, Amit Saxena <learn.tech123@gmail.com> wrote: > Hi all, > > I want to know how to find the status, i....

Is there any way to know the last access time of a table?
I have some junk tables in my database, but I am not sure if they are really not in use. Does sql server log the last time that a table gets accessed? when I say access I mean any actions toward the table, including select, update, insert, etc.thanks in advance. I am unsure about your answer, but you can log it manually to a table by generating stored procedures for selecting/updating/etc.  Specializing in ASP.NET 2.0 thanks for the suggestion. I thought about that too but I can't possibly rewrite all codes across the application for this. also it may be too resource intensive. sho...

How to find out the date/time of when a record was last update?
Hi, Is there a way to determine the date or/time of when a record was last update, w/out using audit ? thanks in advance, Karena Add a timestamp or datetime column to you table to track this. steve [TeamSybase] but is there any way to track it down if i didn't have the timestamp column set up? thanks, Karena Not easily, and probably not at all. For instance, if you have a series of database dumps, you could start loading them and checking the contents of the row until you find the db dumps where it has value (a) in the first dump and (b) in the next dump -...

Oracle, problem updating a table in run-time only.
PB7(10071), Oracle 8 native driver, WinNT4 On one table in my database I can use the datawindow painter to make modifications, but at run-time, the update fails with a generic update error... sqldbcode=0 "No changes made to database." Using the TRACE option for the connection, the dw.update results in the following Trace rows written: (4e309e8): CANCEL: (0 MilliSeconds) (4e309e8): COMMIT: (0 MilliSeconds) (4e309e8): GET AFFECTED ROWS: (0 MilliSeconds) (4e309e8): ^ 7 Rows Affected (4e309e8): BEGIN TRANSACTION: (0 MilliSeconds) Any thoughts on debugging this? ...

date of last update stats & sp_recompile
Hi, How would I check to see when update statistics for a table and sp_recompile on a table was last run? Preferably by means of isql. Thanks. select moddate from sysstatistics where id = object_id("<table name>") You know, this doesn't work in 11.5 or lower version, only for 11.9.2 or higher. Larry Simo wrote: > Hi, > How would I check to see when update statistics for a table and sp_recompile > on a table was last run? > Preferably by means of isql. > Thanks. ...

How to find out the date/time of when a record was last update? #2
...

Updated Date/Time all Time Zones
Hi,I am working on a Web ASP.NET APPLICATION, which has different sub domains for all the different Countries, I need to show the Current Date/Time based on DayLight Saving as well but I am unable to find a perfect solution for this, I am not looking for a Paid WebService as the Site might not show the Date/Time if the Vendor stops that WebService,it is one crucial requirement and I am sure there should be a way in asp.net 2.0 to figure this out.......thanks    A fundamental rule in technology says whatever can be done will be done See this: http://www.timeanddate.com/time/dst200...

date/time or date and time
I am setting up an SQL database and I will need to get differences in dates. For example I have a start date, start time, completion date and completion time and I want to get the difference between the start and completion. Would it be better to have one field with both date and time in it, or better to have a date field and a time field? Even though I have already started setting up the tables with seperate fields for date and time I am now leaning toward one field with date/time in it. (Only because that is the way I had to do it when setting up an Excel spreadsheet for a similar ta...

Update Only the Time in a date time field
Hi,i have a table having a datatime field and on a datagrid I need only to display and update the time part. I'm using select CONVERT(CHAR(8), JobStartTime, 8) AS StartTime from table to get the date. What is  the best way to write the update command . What woul dbe the best approch.   Regards, Vijay  1. Instate of doing formatting in the SQL, Try to do that is the DataGrid with FormatString. 2. To Update the Database , you can do that in two ways.    a. Either go for Store Procudure. Send the TIME you want to set for record. Your SP should some ...

Membership.GetUser() does not update the last-activity date/time stamp for the user
I am writing the "Who is online" function for my application and found that Membership.GetUser() does not update the last-activity date/time stamp for the user as expected. This make my application considers a user offline after he/she logs into the system after the number of minutes specified in the "userIsOnlineTimeWindow" property (even he/she is still working in the application). I have searched on web all day and found no clues on this problem.Has anyone encountered the same kind of problem? Any help would be greatly appreciated.Thanks a lot.  Membership.GetUs...

ASE 12: Update Stat on index column takes 3 hours to run
I have 1 table has over 15 million rows. It has 1 composite unique clustered index with 6 columns. It takes over 3 hours to update statistics on 1 column not a leading column. The hardware is Sun 4 cpu Ultra 80, OS 2.8, 4G memory, EMC drives, Sybase ASE 12 with 3.5G memory, 200M 4K, 200M 16K. Any tuning tips on this... Will Sybase next release make some improvement on update stat? Ray some ideas: - set 'global cache partitions' or ('local cache partitions' if the table has it's own dedicated cache' to the number of cpus to avoid spinlock contenti...

Knowing if a component is at Design time or Run time
I have a composite customer server control that requires access to the Page object to render its children correctly. protected override void CreateChildControls() { // add the wizard bars prepared in the constructor AddWizardBars(); // parse web.config and load all wizard step controls if (this.Page!=null) //do not enter here if we are working with the designer { LoadSteps(); if (!Page.IsPostBack) //initialize only first time control is loaded on page MoveForward (null, InitialStep); } } While this works correctly at run ...

updating Oracle date column without update time
Hello, I have an oracle table with a Date column. When I do a DW update(), the generated update is as follow : update table set date_maj = to_date('15-09-2000 15:09:14','DD-MM-YYYY HH24:MI:SS') But I don't want the TIME to be updated, I'd like a format like : to_date('15-09-2000 00:00:00','DD-MM-YYYY HH24:MI:SS') where the time is set to midnight, wich is the Oracle default for date columns when you don't want to treat with time. I'm using 7.02 build 8046, and I think the behaviour in previous versions was not the same. ...

Update stats vs. update all stats
Under 11.9.2 update all stats will build stats for all columns, even those not used in an index, providing more information to the optimizer. It seems like we would always want to run update stats with the all option so that the optimizer has more information to work with. Is this valid ?? I am wondering if I should change my update stats jobs to use the all option. Any experiences or suggestions would be appreciated. Thanks Jerry Horochowianka Jerry Horochowianka wrote: > > Under 11.9.2 update all stats will build stats for all columns, even those > not used in...

run insert 1 table and update 1 table at a same form
I need to insert a group of data into table1 and at the same time update table2 field. Anyone know how to do it. By the way, I'am using VWD. You run two separate queries, one for the INSERT and one for the UPDATE.  The alternative is to program it in SQL, possibly as a trigger, but it depends on wht you're really doing. JeffPlease: Don't forget to click "Mark as Answer" on the post that helped you. That way future readers will know which post solved your issue....

Schema problem with ZCM 10.3 update - please see TID 7005581
-- Shaun Pond Seems to imply that if you are setting up a new system you are okay? -- kjhurni ------------------------------------------------------------------------ kjhurni's Profile: http://forums.novell.com/member.php?userid=734 View this thread: http://forums.novell.com/showthread.php?t=406485 The known issues for why it was pulled have to deal with Upgrades. The 10.3.0 ISO is not being pulled at this time nor is that expected to happen. Fresh installs should be fine. On 4/1/2010 4:26 PM, kjhurni wrote: > > Seems to imply that if yo...

How can I add on run-time a row to asp:table in the middle of the table...
in the position that i choose. for example: i have a table with 10 rows and 3 columns i want from the 5 place to add a row bellow. is... this.Table1.Rows.AddAt(5, new TableRow()); ...what you are looking for?Regards,TripleTwenty...

How to get powerbuilder library version, date-time stamp at run-time?
Hi, We would like to see list of all libraries of running application along with their version and date/time stamp (in about window). We would like to get version number of compiled powerbuilder libraries (pbd's) at run-time. I don't know if pibbles compiled in dll format have advanced features (as regular dll - where right clicking on it and selecting properties will allow user to see version number of dll). Anyway, compilation of pibbles in dll format is not an option for us. I would like to see if anybody came across a solution and would like to share it with me. I ...

superreview canceled: [Bug 88454] fast-update.pl: add automatic "last update time" & update whole tree : [Attachment 117305] diffs against brad-fast tinderbox to add few fixes from bbaetz
Serge Gautherie <sgautherie.bz@free.fr> has canceled superreview: Bug 88454: fast-update.pl: add automatic "last update time" & update whole tree https://bugzilla.mozilla.org/show_bug.cgi?id=88454 Attachment 117305: diffs against brad-fast tinderbox to add few fixes from bbaetz https://bugzilla.mozilla.org/attachment.cgi?id=117305&action=edit ...

Last updated date
Is there a way to find the date a table was updated. I can't find anything in the documentation. Thank you. Do you mean when the structure was updated or the data? There is nothing to support the former and the latter would require you to include an audit column of type DATETIME that is updated on each insert or update. -- Jim Egan [TeamSybase] Houston, TX Sybase Developers Network http://sdn.sybase.com/sdn/mec/mec_home.stm This is interesting, Jim. There really isn't any statistic maintained on when a table was created or structurally changed. This was on purpo...

Last Date Updated
I am looking for a module which should show the last date the site was updated. I tried to find old topics related with this issue but the results were unrelated.. I am using DNN212. Can anyone help? I guess this module is in the WANTED list by a lot of ppl... Thank you for your help! [/antonisc] nobody? i thought it was an interesting topic but.. It is an interesting topic, but the challenge lies in figuring out what updated means in the context of any number of modules. It would require a standard way for all modules to notify the core when their content has been modifi...

Date Time updating
Hello, I have a problem with updating a field in one of my data tables. It is a datetime field - On one of my pages there is an update where the user fills in the date for scheduling purposes. there is another date field that is for a completion date. the second textbox is usually going to be left blank on the first update. When the update takes place the completion date fills in the table a date that is 1/1/1900 12:00:00 AM I want to avoid this and keep the field in the table blank or null. How can this be done to avoid the 1900 date. Thanks E You can av...

Web resources about - How do you know the last date/time update stats is run on a table? - sybase.ase.general

Saturday Night Live Weekend Update Thursday - Wikipedia, the free encyclopedia
Saturday Night Live Weekend Update Thursday is an American limited-run series broadcast on NBC . It is a political satire news show spin-off ...

Gizmodo.com Updates
Nobody should have to use a pay phone , natural disaster or no natural disaster. So if your gadgets are out of juice after Sandy, here’s a tiny ...

Lifehacker.com Updates
By Whitson Gordon Ever run into a situation where you have multiple wireless networks available, but one is clearly better than the other? WiFi ...

Facebook Messenger For Android Update Includes Conversation Shortcuts
Facebook released an update to its Android Messenger application that incorporates the group -creation and message forwarding features in last ...

Apple confirms OS X update broke Ethernet port on some Macs, here’s how to fix
... it, as is the case with most Macs sold today, then it may have accidentally broke the port last week in an OS X kernel extension update. Many ...

UPDATE: Daesh claims responsibility for twin suicide bombing in Baghdad
UPDATE: Daesh claims responsibility for twin suicide bombing in Baghdad

You’ll have to wait until Q2 for your Asus Marshmallow update
... and it looks like the situation won’t change for another few months. Asus announced on its forums the devices that will receive the update to ...

Most software already has a “golden key” backdoor—it’s called auto update
(credit: martinak15 ) Leif Ryge is an artist, hacker, and journalist living in Berlin. He used to tweet as @wiretapped but is on hiatus until ...

Apple confirms that it accidentally broke Ethernet ports on some Mac computers with a software update ...
Apple's latest software update for Macs had an unintended consequence: it broke Ethernet network ports for some older Mac computers, meaning ...

Obama updates Americans on ISIS fight, Syria ceasefire - Videos - CBS News
"I can report that we're making progress" in the fight against terrorists abroad, the president said in his weekly address

Resources last updated: 2/29/2016 3:06:08 AM