| Back to Questions Page |
| |
| Question |
how to do application monitoring through AutoSys? |
Rank |
Answer Posted By |
|
Question Submitted By :: Jiban |
| This Interview Question Asked @ Cognizent |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Following Tools can be used to Monitor the application jobs.
JobScape
Unicenter Enterprise Job Manager - Web Console
Unicenter Workload Control Center - Web Console
JAWS
iXP
Autosys Web Interface
Additionally Contact Computer Associates for further
information regarding the Licencing.  |
| Rajnish Mansani |
| |
| |
| Question |
can i gat any proper material for sybase
if possible plz let me know
balaji.cc1@gmail.com |
Rank |
Answer Posted By |
|
Question Submitted By :: Bala |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | sybase.com
infocenter.sybase.com
except this sites  |
| Bala |
| |
| |
| Answer | Hi, Try to register yourself as a user at the following
link and try your luck.
https://login.sybase.com/login/userLogin.do?referer=http%3A%
2F%2Fdownloads.sybase.com%2Fswd%2Fbase.do
One more link where you can find a good material is
http://www.sypron.nl/main.html  |
| Pavan |
| |
| |
|
|
| |
| Question |
What is a temp table? how to denote temp table? |
Rank |
Answer Posted By |
|
Question Submitted By :: Mj |
| This Interview Question Asked @ Oracle |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Any table with name starting with '#' is automatically put
into tempdb database.
Temp tables allow developers to create and scan tables
within a stored procedure - and
have the tables totally isolated from all other database
connections. This is very
valuable when results need to be processed several times
within a loop, or when
a complex result set is expected (like a crosstab). Note
that temp table transactions
are logged within tempdb (exception: select into create
statements).  |
| Leena Bejoy |
| |
| |
| Answer | temp table is a temporary table,any user can use this
temptable,it is one of the required database  |
| Thangaprakash.r |
| |
| |
| Answer | Hi, This answer is with respect Sybase ASE database
# temp-table
A temp table is created with a prefix of #. These are
session specific. That means if user-1 creates some temp
tables with #<some name> and logs out and then logs-in into
the database, he will not be able to see the #<table> which
he created.
Shareable temp-table
In turn, if the user creates tables in tempdb without
any "#" , then the table becomes shareable temp table.
These will remain in tempdb till the ASE is rebooted. If
the user logs-out and then logs-in , even in second
sessioin he can still access these table.
- Pavan  |
| Pavan |
| |
| |
| Question |
what means of sybase ?? and how i can use sybase data base
on my computer
Iam the first use it >> any help please ! |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | To know what is Sybase please read the web-page at
following link
http://www.sypron.nl/whatis_ase.html
To download Sybase ASE ( Developer edition ) which is free
and very easy install, please visit the following link.
Download "Sybase ASE 15.0 for Windows x86" if you OS is
windows. Along with the download , the Sybase gives
detailed instructions on how to install, learn and use the
Sybase ASE.
http://www.sybase.com/ase_1500devel
PN: "Sybase ASE" is the database name ; 15.0 is the
version; windows x86 is what you want as you have a windows
OS on your PC.
- Pavan  |
| Pavan |
| |
| |
| Question |
In sybase, we can have multiple users associated to same
login ,each corresponds to different databases, right? how
can we login to one database with corresponding user id? |
Rank |
Answer Posted By |
|
Question Submitted By :: Suja |
| This Interview Question Asked @ ISRO |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Yes, it’s possible that we can login to one database with
corresponding user id. Because we can have multiple users
associated to same login, each corresponds to different
database, so
We can login to one database with corresponding user id by
issuing command from command prompt
is : isql –U_user id –P_password –D database_name  |
| Rashmita |
| |
| |
| Question |
Sybase system databases |
Rank |
Answer Posted By |
|
Question Submitted By :: Prabhu |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | When you install Adaptive Server, it contains these system
databases:
The master database controls the user databases and the
operation of Adaptive Server as a whole. It stores
information about all user databases and their associated
database devices.
The model database is used by Adaptive Server as a template
for creating new user databases.
A new database cannot be smaller than the model
database.
? The sybsystemprocs database contains the system stored
procedures.
The sybsystemdb database contains information about
distributed transactions.
? The temporary database, tempdb, stores temporary objects,
including temporary tables created with the name
prefix ?tempdb..?.
? The sybsecurity database, contains the audit system for
Adaptive Server. It consists of:
The system tables, sysaudits_01, sysaudits_02, ...
sysaudits_08, which contain the audit trail
The sysauditoptions table, which contains rows describing
the global audit options.
All other default system tables that are derived from model
 |
| Prabhu |
| |
| |
| Question |
Sybase 12.5 Database Statistics (Maximum) |
Rank |
Answer Posted By |
|
Question Submitted By :: Prabhu |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Databases per Adaptive Server Enterprise - 32,767
Server Size - 8 terabytes
Database size - 4 terabytes
Page Size - 2K, 4K, 8K, 16K
Databases spanned by one update 16
Databases opened by one transaction 16
Tables in a query 50
Logins per server 2,147,516,416
Users per database 2,146,484,223
Groups per database 1,032,193
Columns per table 1024
Arguments to stored procedure 2048
 |
| Prabhu |
| |
| |
| Question |
what is the architechure of sybase ASE? |
Rank |
Answer Posted By |
|
Question Submitted By :: Murali |
| This Interview Question Asked @ ocbc |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | The Sybase Server
A Sybase server consists of:
a) Two processes, data server and backup server.
b) Devices which house the databases; one database
(master) contains system and configuration data.
c) A configuration file which contains the server
attributes.
Memory Model
The Sybase memory model consists of:
a) The program area, which is where the dataserver
executable is stored.
b) The data cache, stores recently fetched pages
from the database device.
c) The stored procedure cache, which contains
optimized sql calls.
A database device stores the objects that make up
databases.
The term device does not necessarily refer to a
distinct physical device: it can refer to any piece of a
disk (such as a disk partition) or a file in the file
system that is used to store databases and their objects.
Each database device or file must be prepared and made
known to Adaptive Server before it can be used for database
storage. This process is called initialization.
A segment is a label that points to one or more database
devices. When you first create a database, Adaptive Server
creates three segments in the database,
System: Stores the database?s system tables.
Logsegment: Stores the database?s transaction log.
Default: Stores all other database objects?unless you
create additional segments and store tables or indexes on
the new segments by using create table...on segment_name or
create index...on segment_name  |
| Prabhu |
| |
| |
| Question |
How do you troubleshoot if your tempdb gets filled |
Rank |
Answer Posted By |
|
Question Submitted By :: Guest |
| This Interview Question Asked @ HCL |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | use tempdb
go
sp_helpsegment "default"
go
 |
| Sri |
| |
| |
| Answer | Do any of the following
1. restart the sybase database server
2. alter the size of the tempdb  |
| Prabhu |
| |
| |
| Answer | If your tempdb gets full you can do one of following:
you can expand your tempdb or you can use
select lct_admin(0,2)
go
It will abort all open transactions.But be sure the task by
confirming with the concern users.
Restarting the server is not recommanded.  |
| Kk07 |
| |
| |
| Answer | lct_admin (0,2) would abort all open transactions, or you
can go for altering the tempdb space. Multiple tempdb's is
a feature which can be implemented to minimize such issues
of tempdb getting full.  |
| Ajith Prabhakaran |
| |
| |
| Answer | if the system temp db gets filled, even sa cannot get
connected to that temp db to check which processes are
blocking, in order to avoid this , a good concept of
multiple temp dbs can be implemented and we can create temp
dbs and assign newly created temp db to sa, so that sa
could get the info of the processes that is blocking temp
db, ab=nd by using lct_admin or some other commands we can
abort that blocking transaction.  |
| Bindu |
| |
| |
| Answer | use tempdb
go
sp_helpsegment "default"
go
 |
| Sanjeev Shekhar |
| |
| |
| Answer | If the transaction log of tempdb is full then you call
login through sa and type following command.
> dump tran tempdb with trancate_only
> go
If the database is full then you can increase the size of
the database on a free device.
> alter database tempdb on device_name = size
> go  |
| Aditya |
| |
| |
|
| |
|
Back to Questions Page |