Newest sql Questions Stack Overflow. Structured Query Language SQL is a language for querying databases. Questions should include code examples, table structure, sample data, and a tag for the DBMS implementation e. My. SQL, Postgre. SQL, Oracle, MS SQL Server, IBM DB2, etc. UFa.png' alt='Sql Server Update Sequence Number Db2' title='Sql Server Update Sequence Number Db2' />If your question relates to a specific DBMS. This paper focuses on a number of DB2 tuning tips based on lessons learned from running Online Transaction Processing OLTPtype performance benchmarks TPCC, TPCW. What are the benefits of installing SQL Server on a Windows Failover Cluster Learn about the strengths, weaknesses, and gotchas of clustering SQL Server. Sql Server Update Sequence Number Db2 DateDB2 LUW DBA How. To DB2 LUW DBA Candidate Interview Question Sampler. Here is an outline of questions and topics I recently prepared for interviewing new candidates for my current client. Besides these questions, I would also be looking for the following qualities in a strong candidate Strong English language skills. Can describe a documentation philosophy and has some writing samples. Good face to face communication skills and easy going personality. Proactivity, doesnt wait for someone to tell her what to do. Active Speakers For Home Dj Free. Creativehacking approach to database problems, especially if you want a performance specialist. A geek with outside technical interests is ideal. Someone with a background in database development and some years in at least one non database programming language someone who can understand development challenges. The Interview Outline. DB2 Process and Memory Model. What is the difference between an Application and an Agent How can you see physical memory core utilization by a Unix DB2 serverSql Server Update Sequence Number Db2 ErrorWhat is the memory used by sorts SORTHEAPWhat is the difference between the DB2 host machine, the instance, and the database Tell us something about DB2 memory structure root is Instance shared memory, below that is Database shared memory within each Database there is Application Group shared memory, then each Agent has private memory. How do we control or influence the allocation of these memory sets DB and DBM CFG, creation and configuration of bufferpoolsConfiguration down to Database Level. What command allows me to see all instances set up on a host What command lets me see databases defined on an instance that I am attached to How can I see what the DB2 registry variables are What will show me instance configuration What will show me database configurationWhat are the some of the scopes of configuration starting at the network as a whole, and working down to the database not including objects within the database, that can affect non partitioned DB2 Try to get as many as possible. Could include A.      Network configuration including ODBC configuration of DB2 clients and configuration of DB2 Connect gateway machines. B.      Backup server and monitor server configuration. C.      Cluster configuration. D.      OS kernel configuration E. Server physical and swap virtual memory, disk storage amount and type, and number and type of processors. F.       DB2 registry db. G.      Instance configuration GET DBM CFGH. Node catalog IP address and portI. Database catalog. J.        Database configuration GET DB CFGBackup Net. Backup familiarity What are the differences between offline and online backup What are the advantages and disadvantages of each When first setting up and then later maintaining a database, what would be your main concerns with backupHow can you learn more about a backup that was done five days ago LIST HISTORYRestore Redirected Restore describe the basic steps required. What do you need to restore DB2 to a point in time Logging What are the kinds of loggingWhen would you use one kind of logging and not another What kind of maintenance needs to be done with logsWhat database configuration parameter establishes the minimum number of logs LOGPRIMARYStarting and stopping DB2 How would you stop DB2 if db. If db. 2start is taking a long time, what should you do If db. How can you determine that the DB2 engine is running Space Organization Describe the kinds of tablespaces. SMS and DMS physical organization types and object types REGULAR, LARGE, SYSTEM TEMPORARY, USER TEMPORARY What relationship does type of tablespace have to backup DMS allows online tablespace level backups Where can Large Objects LOB resideLARGE tablespaces What is the relationship between tablespace and bufferpool How can you determine the amount of space utilized on the filesystems of a Unix host Unix Before I can do work within an instance, what must be done Answer attach to the instance, generally by setting the value of environment variable DB2. INSTANCE in your. What are some common DB2 command line options, and what do they do How might you use a Unix utility to streamline or automate your workWhat common UnixSolaris commands would you use to query the state of the database host How do you copy a line and paste to another location in vi High Availability What kind of high availability environment do you have experience with If Solaris Cluster, ask relevant questions. Windows Which Windows utilities would you use to do your job Are you familiar with Wikis for documentation How do you document your workPerformance Describe operating system metrics you would check for performance problems, and what numbers might indicate a problem. CPU user 9. 9 1. Describe the main database performance and troubleshooting tools db. SNAPSHOT, EVENT MONITOR Tell us more about what data elements you might look at in a snapshot How can I tell that a bufferpool might be too small Describe performance numbers or calculations that can indicate database performance is not optimal e. SQL execution time, high number of rows read on a specific table indicating tablescanSQL How to see the access plan for SQL EXPLAIN What are the two ways that an application can submit SQL Describe a left outer join, when would it be used How can you make sure you only return 1. FETCH FIRST 1. 0 ROWS ONLY If I make a change such as create index that can improve the performance of SQL, what do I have to do to make sure the performance change takes effect RUNSTATS after the index was createddropped for static SQL do a rebind for dynamic SQL, FLUSH PACKAGE CACHE DYNAMIC. What is the shortest way to show the current database timestamp on DB2 command line db. Describe a correlated subquery. What is a common table Can I view dynamic SQL that has been run in the database in the past YES if it is still in dynamic package cache. How can I view the SQL that is still in dynamic package cache GET SNAPSHOT FOR DYNAMIC SQL ON lt dbname Tables. Columns and Indexes Describe the kinds of table related maintenance you might expect to do reorg, runstats, table snapshot for unusual readwrite activity, reorgchk. What is a reorg For standard maintenance how would you use runstats and reorgsIf a table was constantly busy, how could you run runstats and reorgs, or would you Describe two ways to create a primary key. Describe the components of a table that are needed to establish referential integrity between two tables. How to easily assign an incremented an unique value to a column IDENTITY also used triggers with SEQUENCE objects What command shows me the structure of a table DESCRIBE TABLE lt tabschema. What is a quick way to see the indexes for a table DESCRIBE INDEXES FOR TABLE lt tabschema. Process concurrency How can you detect a problem with table locking How can you see all the connected processes running against the database DB2 LIST APPLICATIONS How to see utilities that are runningDB2 LIST UTILITIES, I think this is version 9 or 8.