https://wiki.gacq.com/index.php?action=history&feed=atom&title=Sybase
Sybase - Historial de revisiones
2026-04-04T19:40:11Z
Historial de revisiones para esta página en el wiki
MediaWiki 1.29.2
https://wiki.gacq.com/index.php?title=Sybase&diff=2342&oldid=prev
Gacq: /* Comandos varios */
2006-12-15T01:41:18Z
<p><span dir="auto"><span class="autocomment">Comandos varios</span></span></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;' lang='es'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Revisión anterior</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revisión del 01:41 15 dic 2006</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l15" >Línea 15:</td>
<td colspan="2" class="diff-lineno">Línea 15:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><pre><nowiki></div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div><pre><nowiki></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"># Cambiar password nula</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">sp_password null,nueva</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>update statics - Rearma Indices</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>update statics - Rearma Indices</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>sp_recopile - recopila los stor proc</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>sp_recopile - recopila los stor proc</div></td></tr>
</table>
Gacq
https://wiki.gacq.com/index.php?title=Sybase&diff=1495&oldid=prev
192.168.0.105 en 19:38 27 jul 2006
2006-07-27T19:38:26Z
<p></p>
<p><b>Página nueva</b></p><div>= Problema de instalacion de sybase en linux =<br />
<br />
Instalacion en Linux y problema con o_create<br />
<br />
You can edit /etc/sysctl.conf and add<br />
<pre><nowiki><br />
kernel.shmmax =40452096<br />
</nowiki></pre><br />
(so that the value will be set each time you reboot) and you can set it manually with <br />
<pre><nowiki><br />
sysctl -w kernel.shmmax=40452096 <br />
</nowiki></pre><br />
<br />
= Comandos varios =<br />
<br />
<pre><nowiki><br />
update statics - Rearma Indices<br />
sp_recopile - recopila los stor proc<br />
dbcc - checkea consistencia<br />
set show plan on<br />
set noexec on - idem pero no exec<br />
select into/bulkcopy - Habilita esto<br />
</nowiki></pre><br />
<br />
Aumentar la memoria cache<br />
<pre><nowiki><br />
sp_configure "procedure cache", 30<br />
go<br />
sp_configure "users conexions", 65<br />
go<br />
reconfigure<br />
go<br />
shutdown<br />
go<br />
</nowiki></pre><br />
<br />
<pre><nowiki><br />
dbcc traceon (3604)<br />
</nowiki></pre><br />
<br />
<pre><nowiki><br />
disk mirroring<br />
disk mirror<br />
name = "devicename",<br />
mirror = "physicalname"<br />
</nowiki></pre><br />
<br />
<pre><nowiki><br />
dump tran agc with no_log <br />
<br />
disk init name = "agc2", physname = "/home/u/NetCmmnd/agc2", vdevno = 4, size = 25000<br />
<br />
Extend database:<br />
1> disk init name="database device",physno="data full path ",vdevno=unique number,size=size in 2k bytes<br />
2> go<br />
ej:<br />
1> disk init name="ctrlm_ux",physno="/home/ecs/sybase/ctrlm_ux.dat",vdevno=4,size=10240<br />
2> go<br />
1> disk init name="ctrlm_log",physno="/home/ecs/sybase/ctrlm_log.dat",vdevno=5,size=4090<br />
1> alter database ctrlm log on ctrlm_log1=10<br />
2> go<br />
Erase suspect flag:<br />
1> sp_configure 'allow updates', 1<br />
2> reconfigure with override<br />
3> go<br />
1> update sysdatabases<br />
2> set status = status -256<br />
3> where name='<database name>'<br />
4> and status & 256 = 256<br />
5> go<br />
6> sp_configure 'allow updates',0<br />
7> reconfigure<br />
8> go<br />
shutdown and restart database server<br />
</nowiki></pre></div>
192.168.0.105