Discussion:
No transaction log on specific table
(too old to reply)
unknown
2010-01-12 14:32:04 UTC
Permalink
hi,

is there a way in ASE 15.0.3 to have no transaction log on
specific table?

Now we create the table in tempdb, but i'd rather have the
table in my own database. Its updated frequently, so it
generates a lot of transaction log, its very temporary data
so i don't want this transaction log...

Greetz
Pieter

ps: when looking for it, i noticed that its possible in
oracle ;)
Jason L. Froebe [TeamSybase]
2010-01-12 14:58:10 UTC
Permalink
Post by unknown
hi,
is there a way in ASE 15.0.3 to have no transaction log on
specific table?
Now we create the table in tempdb, but i'd rather have the
table in my own database. Its updated frequently, so it
generates a lot of transaction log, its very temporary data
so i don't want this transaction log...
Greetz
Pieter
ps: when looking for it, i noticed that its possible in
oracle ;)
In v15.5, you can use the IMDB in memory database option to achieve
something similar :)

jason
Rob V [ Sybase ]
2010-01-12 15:00:37 UTC
Permalink
Not in 15.0.3, but in the recently released ASE 15.5, what you want is
possible. Though you cannot switch the transaction log off, 15.5 allows you
to use minimally logged DML, which is probably what you're after. Note that
this requires the IMDB license option for ASE 15.5.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:***@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------
Post by unknown
hi,
is there a way in ASE 15.0.3 to have no transaction log on
specific table?
Now we create the table in tempdb, but i'd rather have the
table in my own database. Its updated frequently, so it
generates a lot of transaction log, its very temporary data
so i don't want this transaction log...
Greetz
Pieter
ps: when looking for it, i noticed that its possible in
oracle ;)
unknown
2010-01-12 15:51:23 UTC
Permalink
Hi,

thx for the response! I will have a look at it once we are
ready to upgrade...

Greetz
Pieter
Post by Rob V [ Sybase ]
Not in 15.0.3, but in the recently released ASE 15.5, what
you want is possible. Though you cannot switch the
transaction log off, 15.5 allows you to use minimally
logged DML, which is probably what you're after. Note
that this requires the IMDB license option for ASE 15.5.
HTH,
Rob V.
----------------------------------------------------------
------- Rob Verschoor
Certified Sybase Professional DBA for ASE
15.0/12.5/12.0/11.5/11.0 and Replication Server
15.0.1/12.5 // TeamSybase
Author of Sybase books (order online at
www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
Reference Guide" "The Complete Sybase Replication Server
Quick Reference Guide"
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
----------------------------------------------------------
-------
Post by unknown
is there a way in ASE 15.0.3 to have no transaction log
on specific table?
Now we create the table in tempdb, but i'd rather have
the table in my own database. Its updated frequently, so
it generates a lot of transaction log, its very
temporary data so i don't want this transaction log...
Greetz
Pieter
ps: when looking for it, i noticed that its possible in
oracle ;)
unknown
2010-01-14 08:23:06 UTC
Permalink
Pieter,
Have you tried to populate the table with fast BCP without any indexes?... This has a minimal Transaction log.
--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0
Post by unknown
hi,
is there a way in ASE 15.0.3 to have no transaction log on
specific table?
Now we create the table in tempdb, but i'd rather have the
table in my own database. Its updated frequently, so it
generates a lot of transaction log, its very temporary data
so i don't want this transaction log...
Greetz
Pieter
ps: when looking for it, i noticed that its possible in
oracle ;)
unknown
2010-01-18 07:29:57 UTC
Permalink
Cory,

The tables are not filled by importing data, the data is a
result of existing data in our tables...

Greetz
Pieter
Post by unknown
Pieter,
Have you tried to populate the table with fast BCP without
any indexes?... This has a minimal Transaction log.
--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0
Post by unknown
is there a way in ASE 15.0.3 to have no transaction log
on specific table?
Now we create the table in tempdb, but i'd rather have
the table in my own database. Its updated frequently, so
it generates a lot of transaction log, its very
temporary data so i don't want this transaction log...
Greetz
Pieter
ps: when looking for it, i noticed that its possible in
oracle ;)
Kristian
2010-01-21 08:54:27 UTC
Permalink
Hi,

Did you consider using delayed commit? It can be set on a session level or
at the database level.

Regards,
Kristian
Post by unknown
hi,
is there a way in ASE 15.0.3 to have no transaction log on
specific table?
Now we create the table in tempdb, but i'd rather have the
table in my own database. Its updated frequently, so it
generates a lot of transaction log, its very temporary data
so i don't want this transaction log...
Greetz
Pieter
ps: when looking for it, i noticed that its possible in
oracle ;)
Loading...