dbi and dbcc on WinNT 4.0
Hi,
Right now, I am working on a dbcc perl script for a Sybase database. I
have noticed that I get a different output with dbi (do(do checkdb ...))
than with isql. What can I do to get the same output with dbi as with
isql. I plan to use the output to check the database for any kind of
inconsistencies.
Any help would be highly appreciated.
Tobias Hausmann
# check database integrity
sub checkdbintegrity
{
my @searchlist = qw (Msg Level State error: corrupt);
my $sth1 = $dbh->prepare("select name from sysdatabases");
$sth1->execute();
while( my $dbname = $sth1->fetchrow_array)
{
$sth = $dbh->do("dbcc checkdb ($dbname)")
#process output
$dbh->errstr();
.
}
}
isql output:
Checking master
Checking sysobjects
The total number of data pages in this table is 4.
Table has 64 data rows.
Checking sysindexes
The total number of data pages in this table is 7.
Table has 76 data rows.
Checking syscolumns
The total number of data pages in this table is 17.
__
dbi do(checkdb checkdb(db)) output:
Server message number=2536 severity=10 state=2 line=1 text=Checking
master
Server message number=2536 severity=10 state=3 line=1 text=Checking
sysobjects
Server message number=2579 severity=10 state=1 line=1 text=The total
number of d
ata pages in this table is 4.
Server message number=7929 severity=10 state=1 line=1 text=Table has 64
data row
s.
Re: DBD-Oracle 1.0.7/AIX make problem
I replaced the AIX make with a GNU make and deleted the following lines
from the make file
# these two targets are the same as the ones above extproc_no_context
and
# extproc_with_context. They are preserved for backward compatibility.
/bin/nm -B -h -g "$$1" | grep -v ' U ' | awk '{print $$3}' |
\
egrep -v '^\.|^TOC' | sort | uniq ; \
}; \
generate_export_list $(OBJS) > $(SHARED_LIBNAME).exp; \
$(LD) -bnoentry -bM:SRE -bE:$(SHARED_LIBNAME).exp -o
$(SHARED_LIBNAME)\
$(OBJS) -L$(ORACLE_HOME)/lib -lc_r $(OCISHAREDLIBS) $(LIBEXTP) \
$(LIBSQL) $(TTLIBS) $(DEF_OPT) $(SSDBED) $(LIBAGENT)
$(LIBEPCPT)
Both actions fixed the problem.
Thanks you,
Tobias
Gilmour Sean-WSG014 wrote:
>
> The make that ships with 4.3.3 is not that great, you can either get the gnu-make or
>download a newer c compiler from IBM, I downloaded the latest visual age c++ and it
>works great.
>
> -Original Message-
> From: Tobias Hausmann [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 06, 2001 5:03 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: DBD-Oracle 1.0.7/AIX make problem
>
> Hi,
>
> I am working on the following environment:
>
> AIX 4.3.3,
> Oracle 8.1.6i,
> Perl 5.00503 ,
> DBI 1.15,
> DBD-Oracle 1.0.7
>
> I am trying to install want to install DBD-Oracle 1.0.7. After perl
> Makefile.PL, make gives me the following error message:
>
> >make
> Makefile:2425: *** missing separator (did you mean TAB instead of 8
> spaces?). Stop.
>
> I replaced the beginning spaces with a tab and became the following
> error message:
>
> >make
> Makefile:2425: *** commands commence before first target. Stop.
>
> __
>
> Makefile:
>
> # these two targets are the same as the ones above extproc_no_context
> and
> # extproc_with_context. They are preserved for backward compatibility.
>
> /bin/nm -B -h -g "$$1" | grep -v ' U ' | awk '{print $$3}' |
> \ <- error line
> egrep -v '^\.|^TOC' | sort | uniq ; \
> }; \
> generate_export_list $(OBJS) > $(SHARED_LIBNAME).exp; \
> $(LD) -bnoentry -bM:SRE -bE:$(SHARED_LIBNAME).exp -o
> $(SHARED_LIBNAME)\
> $(OBJS) -L$(ORACLE_HOME)/lib -lc_r $(OCISHAREDLIBS) $(LIBEXTP) \
> $(LIBSQL) $(TTLIBS) $(DEF_OPT) $(SSDBED) $(LIBAGENT)
> $(LIBEPCPT)
>
> __
>
> Any help or advice will be most welcome.
>
> Tobias Hausmann
--
**
* Tobias Hausmann*
* System Administrator *
* BOSTON MEDICAL CENTER *
* Vose Hall *
* 88 East Newton Street *
* Boston, MA 02118-2393 *
* Work : (617) 414 - 1856*
* Fax : (617) 638 - 8201*
* Pager: (617) 638 - 5795 PIN#: 1936 *
**
DBD-Oracle 1.0.7/AIX make problem
Hi,
I am working on the following environment:
AIX 4.3.3,
Oracle 8.1.6i,
Perl 5.00503 ,
DBI 1.15,
DBD-Oracle 1.0.7
I am trying to install want to install DBD-Oracle 1.0.7. After perl
Makefile.PL, make gives me the following error message:
>make
Makefile:2425: *** missing separator (did you mean TAB instead of 8
spaces?). Stop.
I replaced the beginning spaces with a tab and became the following
error message:
>make
Makefile:2425: *** commands commence before first target. Stop.
__
Makefile:
# these two targets are the same as the ones above extproc_no_context
and
# extproc_with_context. They are preserved for backward compatibility.
/bin/nm -B -h -g "$$1" | grep -v ' U ' | awk '{print $$3}' |
\ <- error line
egrep -v '^\.|^TOC' | sort | uniq ; \
}; \
generate_export_list $(OBJS) > $(SHARED_LIBNAME).exp; \
$(LD) -bnoentry -bM:SRE -bE:$(SHARED_LIBNAME).exp -o
$(SHARED_LIBNAME)\
$(OBJS) -L$(ORACLE_HOME)/lib -lc_r $(OCISHAREDLIBS) $(LIBEXTP) \
$(LIBSQL) $(TTLIBS) $(DEF_OPT) $(SSDBED) $(LIBAGENT)
$(LIBEPCPT)
______
Any help or advice will be most welcome.
Tobias Hausmann
