FBSQL_DB_STATUS(3) 1 FBSQL_DB_STATUS(3)fbsql_db_status - Get the status for a given databaseSYNOPSIS
int fbsql_db_status (string $database_name, [resource $link_identifier])
DESCRIPTION
Gets the current status of the specified database.
PARAMETERS
o $database_name
- The database name.
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns an integer value with the current status. This can be one of the following constants:
o FALSE - The exec handler for the host was invalid. This error will occur when the $link_identifier connects directly to a database
by using a port number. FBExec can be available on the server but no connection has been made for it.
o FBSQL_UNKNOWN - The Status is unknown.
o FBSQL_STOPPED - The database is not running. Use fbsql_start_db(3) to start the database.
o FBSQL_STARTING - The database is starting.
o FBSQL_RUNNING - The database is running and can be used to perform SQL operations.
o FBSQL_STOPPING - The database is stopping.
o FBSQL_NOEXEC - FBExec is not running on the server and it is not possible to get the status of the database.
SEE ALSO fbsql_start_db(3), fbsql_stop_db(3).
PHP Documentation Group FBSQL_DB_STATUS(3)
Check Out this Related Man Page
FBSQL_LIST_FIELDS(3) 1 FBSQL_LIST_FIELDS(3)fbsql_list_fields - List FrontBase result fieldsSYNOPSIS
resource fbsql_list_fields (string $database_name, string $table_name, [resource $link_identifier])
DESCRIPTION
Retrieves information about the given table.
PARAMETERS
o $database_name
- The database name.
o $table_name
- The table name.
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
Returns a result pointer which can be used with the fbsql_field_xxx functions, or FALSE on error.
ERRORS /EXCEPTIONS
A string describing the error will be placed in $phperrmsg, and unless the function was called as @fbsql() then this error string will
also be printed out.
EXAMPLES
Example #1
fbsql_list_fields(3) example
<?php
$link = fbsql_connect('localhost', 'myname', 'secret');
$fields = fbsql_list_fields("database1", "table1", $link);
$columns = fbsql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
echo fbsql_field_name($fields, $i) . "
";;
}
?>
The above example will output something similar to:
field1
field2
field3
SEE ALSO fbsql_field_len(3), fbsql_field_name(3), fbsql_field_type(3), fbsql_field_flags(3).
PHP Documentation Group FBSQL_LIST_FIELDS(3)
Hi all ^_^
Okay, here's the problem:
There's an IBM RS6000 server running AIX 4.3 with Informix database in my workplace. During peak hours, it has about 350 users doing mostly database operations. It has been set up that those users can only log-in the system at one terminal at a time. Due... (3 Replies)
I have an application working in unix accessing oracle 9i database on a IBM AIX Unix 5.2 system.
I want this unix application to retrieve data from a SQL server 2000 server to oracle database.
how can i connect to this SQL server database from a unix application
pls help me if you can (2 Replies)
I don't know if this is better suited for the application section, but here goes.
We are currently running HP-UX 11 as our database server. The database is Progress version 9.1C.
As of late, some of our batch processes that run on the UNIX db server are erroring out because of what appear to... (3 Replies)
HI all,
I want to make a webpage showing the status of services running on a server. for example email, http , etc. That way users can see that server status for themselfs. Maybe even show the status of each virtual domain running on the server. Any way to do this without buying some product?
... (4 Replies)
Hi Everyone,
How to assign the specific value which return from database?
here is the return value from database -->
(return status = 0)
0 <----- this
I only need to get the "0" .. assign to another declare variable.
hope someone will help me..
Please
thank you.. (4 Replies)
I hope I'm posting this in the correct section.
I'm trying to move a database from one server to another. This is the code I'm using...
tar czf - vbdatabase.sql | ssh username@full.domain.com 'cat > /home/cpanelusername/vbdatabase.tar.gz
... but all I'm getting is a ">" and then nothing... (4 Replies)
Hi
We run a script that queries a database via the internet and we need the fast possible connections to the database server.
I have centos server which sends the requests to the database across the internet . it sends upto 800 queries per milliseconds however this using the default... (4 Replies)
hello all, i am trying to find a better to do what i am doing right now...
i have a file called sidlist...which has my database_name and password to the respective database
so something like below.. file is called sidlist and entry is below...
test, abc123
kes12, abcd12
pss, abcd1234... (5 Replies)
Hi,
We have 2 lpars on p6 blade. One of the lpar is having 3 core cpu with 5gb memory running sybase as database. An EOD process takes 25 min. to complete.
Now we have an lpar on P7 server with entitled cpu capacity of 2 with 16 Gb memory and sybase as database. The EOD process which takes... (17 Replies)
Hi,
I have a document oriented database. IF there are multiple instances of the same running, i kill all those and then start the server again. i check for multiple instances within a specific time intervel. i.e. i make use of crontab.
now the server is getting restarted after the cronjob... (8 Replies)
I have one application server, which is Solaris non global zone (dsapid02-dt3d02 - 10.63.76.96) and a database server, which is Linux (db1-serv26 - 10.63.36.117 & 10.63.36.118).
Whenever database admin is starting listener, it starts filling listener log file. Within minutes, it will make file in... (6 Replies)
1. The problem statement, all variables and given/known data:
I need help I get a variant of syntax errors when compiling my script to maintain a database. It's a simple database meant to create/view/maintain vehicles.
2. Relevant commands, code, scripts, algorithms:
my if statements have... (5 Replies)
Hello,
Please help me with a script with which I can check long running processes on the database server and the os is AIX.
Best regards,
Vishal (5 Replies)