View Full Version : db2 answers


Pages : 1 2 3 4 5 [6] 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

  1. DB2 database IDE
  2. instance creation problem
  3. Can I access DB2 DB with Toad Client
  4. IOs in DB2
  5. how to use COALESCE?
  6. DW Specialist
  7. Cursors
  8. Data change table references and SQLCODE -20165
  9. How to compare several rows in one table???
  10. space utiilization in a DMS tablespace
  11. Error While installing DB2 on RHEL5
  12. DB2 & Oracle source code reusability
  13. Db2Viper2beta on Windows Server 2k8beta3?
  14. Can stored procedure have call to subroutines
  15. join with example
  16. fetch cursor
  17. Stored procedures and Global temporary tables
  18. DB2 DBA 702 Certification exam
  19. DB2 Logging in Materialised queries
  20. db2 with cd
  21. Insert into AS400 table locks bacuase of trigger
  22. prevval and nextval for a sequence
  23. Deadlock/timeout error
  24. Stored Procedures Updates
  25. Restoring, can't redirect tablespaces
  26. Sort Performance
  27. Able to alter or drop a table but cannot create the table, when no permissions are given to that user
  28. SSIS and DB2 Schemas
  29. IMPORT with METHOD N
  30. how to import db2move.lst
  31. size of the database ?
  32. DB2mscs command
  33. Granting DML privileges on all the tables of a schema to a user
  34. Runstats Utility
  35. Short circuit boolean eval in trigger WHEN clause?
  36. Sqlcode +97
  37. SQL need to be optimized
  38. Delete/update Sql/400 Stored Procedure Not Working
  39. History query question
  40. Basic Cron job not working in UBUNTU
  41. faster CPU vs more RAM
  42. waiting on archive
  43. Create Table sql0204 error
  44. SQLPRIMARYKEYS corrupted
  45. IBMDEFAULTBP setting
  46. "I" is not valid in the context it is used - db2 command line sql
  47. db2updv8 necessary for FP14 -> FP15?
  48. oad done on a table with nonrecoverable option on a archive loging enabled Database
  49. Main differences between DB2 v7 & v8 in a Z/OS env
  50. Writing a stored procedure in command editor
  51. Write a cobol program without using session table
  52. Improving Performance in DB2
  53. DB2 Not ATOMIC Compund SQLs
  54. Fixpak installation in db2 udb
  55. Syntax to Update Timestamp Column
  56. How to run db2commands in windows cmd prompt
  57. Reason for DB2 error code Sql0204n
  58. How do you get load to reject and not truncate data
  59. DB2 error SQL30081N on AIX version 5.2 / 5.3
  60. dropped a not null column from a table, error while running stats
  61. dropped a not null column, having problem in Update
  62. Definition of empty table
  63. DB2 Installation Problem
  64. Executing DB2 commands from Windows command prompt
  65. The database alias "MONITOR" already exists Can't Not Drop it
  66. Invalid cfg for DAS tools catalog (or maybe db2fm)?
  67. Sorting data within inline queries
  68. Hang on archive
  69. XSU Java package with DB2
  70. Tracking DML changes for important tables
  71. writing output of Stored Procedure to an outputfile
  72. Restore backup performed on Unix server to a Windows server
  73. some arbitrary application ids in "db2 list applications"
  74. tracking DML on important tables
  75. Automatically disconnecting DB2 clients which are inactive for some time
  76. Efficiency of DB2 LOAD RESUME vs REPLACE
  77. fortran db2 on Windows
  78. OracleXMLQuery class with DB2
  79. Unresolved external with DB2 v9
  80. Informix current sessions with database names
  81. ORDER BY CASE Problem
  82. db2 CASE statement in ORDER BY clause
  83. ODBC connection to V7 and V8 databases simultaneously
  84. Verify File before import
  85. Java scalar function slow
  86. .Net Framework Data Provider for DB2?
  87. Table Functions using Db2 on Z/Os
  88. INSERT binary data
  89. Insert using RRN?
  90. DB2 as web service client?
  91. Interface tools for DB2
  92. SQL1032N No start database manager command was issued. SQLSTATE=57019
  93. TSA binary for Windows
  94. That works faster in DB2 for creation of an index?
  95. Adding a not null column to a table with 0 rows
  96. db2_deinstall command
  97. How to use DB2 ODBC on z/os with COBOL
  98. Error comes when insert records
  99. SQL0440N No authorized routine named "||" of type "FUNCTION" having compatible arguments was found.
  100. Mainframe file loaded into DB2 table
  101. Use of SELECT [Fields] INTO [var] in UDFs
  102. How to find out last REORG timestamp ?
  103. HADR primary to standby
  104. ADM1844I - Many Many Warnings in the event viewer... Why ?
  105. DB2 privileges, Direct and Indirect SYSADM
  106. How to Handle IF THEN ELSE IN DB2
  107. Effects of Increasing the locklist parameter
  108. Problem with accessing 2 different tables using the same binary
  109. Combine queries for single output
  110. Another Bizzare Crash...But no Recovery. SOS!!
  111. SQL Server 2000 linked server to Db2 on z/OS
  112. DB2 Merge performance
  113. informix/db2
  114. DB2 function
  115. How to write query with two select statements in db2
  116. SQL or stored proc
  117. rid
  118. Odd Diag Log Message on V9 FP2
  119. load/import in db2
  120. how to change user password
  121. query runtime problems - same tables joined together
  122. How to IMPORT MS EXCEL worksheet in Kanji (Japanese) to db2/400
  123. maximum number of column can be set as Primary key in DB@ V8
  124. updating the locklist
  125. How to get the zero's for unsatisfied fields in group by clause in DB2
  126. Need to connect to Db2server
  127. converting Oracle PL/SQL function to DB2 v9
  128. Sqlstate 42972 from Query
  129. stored procedures perf. question
  130. Data load in DB2
  131. db2 exam 701 dumps
  132. Return columns using db2_columns() via PHP
  133. print value during execution stored procedure
  134. Query question
  135. Indexing of table in DB2
  136. setting user name password and user name for automating create script
  137. High water mark
  138. declared global temp table with merge
  139. The Question about REDIRECT RESTORE
  140. sql error -530
  141. When should we Reorg
  142. Background Process for Reorgcheck
  143. Background Process For Backup
  144. db2 on raid5, striped disks, SAN
  145. Alter column precision
  146. Select null as xyz from sysibm.sysdummy1
  147. fastest way to delete 1 billion rows from a table haveing 9 billion records
  148. Select null as xyz from sysibm.sysdummy1
  149. Generated Column
  150. Poll: DB2 V9.1 Adoption
  151. Count the transactions happened in a database
  152. Describe Sql View
  153. Select From Db2 W/php Error
  154. Not a trial, a commercial tool you can use for no charge for as many databases as you want
  155. Backup Information
  156. compare the tables between TEST and DEV
  157. DB2 Control Center not responding
  158. Is there any attribute which indicate the last access date?
  159. How to determine the DB2 version
  160. Querying "Sequence" in Select statement
  161. Got a intresting problem
  162. Backup Information
  163. Conversion of Oracle 9i to DB2 V9
  164. Software Testing Tools
  165. Sybase to DB2 Data Movement
  166. expanding a default value
  167. DB2 V8 (mainframe) Install - 'Resource Not Available' Msg
  168. how to replicate the SQL Server 2005 Procedure to DB2?
  169. DB2 execute permissions issue
  170. Disabling the DB2DETAILDEADLOCK event monitor
  171. Problem in Automatically generated columns while copying schema
  172. "channel DB2"
  173. When is an offline backup not really offline?
  174. Incorrect results using FULL OUTER JOIN in DB2 v8
  175. DB2 Two "how to" questions - [conditional loading and variable use]
  176. DB2 Automated Backup configuration parameters (DB2 UDB v8)
  177. package name restrictions
  178. Selecting Field Description With DB2 and SQL
  179. Archiving Older Data
  180. SQL0206N "BLOB" error
  181. DB2 on AIX throw exception with SQL that has (
  182. DB2 V8.2 - Value compression question
  183. problem with POSSTR
  184. Error while declaring a global temporary table
  185. INSERT IGNORE in db2
  186. J2EE Professionals for Bahrain
  187. Reading Tables & Columns
  188. db2 restore database
  189. Multi Row Insert using an SP in DB2
  190. exam cost??
  191. using Dynamic SQL for Update
  192. Express-C
  193. DB2 Viper 2 compatibility features
  194. Dump of a schema in DB2 / Admin_Copy_Schema
  195. Database Size Problem
  196. Funny
  197. Help me on Query fine tune.Explain report details provided.
  198. Problem with AutoCommit & problem with XML insert
  199. Db2
  200. setting the termination character in CLP
  201. Nested case in DB2
  202. Nested case
  203. DB2 Z/OS Stored proc help
  204. Db2
  205. setting pause on output in CLP (Db2 9)
  206. How to change a column from a not null to null
  207. Oracle EXPORT and DB2 LOAD
  208. SAP DB2 userids
  209. Perl DBD::DB2 connect error
  210. COM.ibm.db2.jdbc.app.DB2Driver
  211. How to insert and retrive data from Visual Stidio 2005 (MFC) into DB2???
  212. IBM][CLI Driver] SQL1032N No start database manager command was
  213. How to export resultset to CSV
  214. How to export resultset to CSV
  215. How to export resultset to CSV
  216. How to export resultset to CSV
  217. How to export resultset to CSV
  218. if "all applications disconnection" is anathor tigger of page cleaner?
  219. killing application/thread automatically
  220. importing data with CR-LF
  221. Insert values into a table B based on a flag on table A
  222. Sql performance Tuning
  223. Database inconsistant?
  224. Sql-Translation: Oracle to DB2
  225. DB2-quries
  226. lock escalation
  227. Unicode...
  228. Tablespace STUCK in Roll Forward in Progress State...
  229. How to make a generated column function of other columns?
  230. db2 pring command for dynamic queries
  231. Calling a nested stored procedure in DB2
  232. Performance of JOIN vs. singleton SELECTs
  233. How many cursors?
  234. What are the process to add another DB2 database to existing Instance?
  235. connect as400 to mysql
  236. substr of a number's field
  237. Emptying index advisor cache
  238. DotNet compatibility of BLOB datatype
  239. positioned update
  240. Tablespace remains full after deletions
  241. Big problem with DB2 and Clobs...
  242. How can i Connet from 1 DB2 Server/Client to Remote Server on AIX
  243. The Best DB2 Articles
  244. DB2 Automated Backup configuration parameters.
  245. Need help getting DB2 Connect to catalog a remote AS400 DB2 server
  246. Load Data from fixed length/delimited feed file
  247. How to get System Date in DB2 with SQL Statements
  248. I need help to fine tune below query..urgent please.
  249. MIGRATE DATABASE from 7.2 to 8.2
  250. How to find no.of deleted rows
  251. DB2 SQL error: SQLCODE: -551, SQLSTATE: 42501
  252. Examination 070-229 Resource
  253. ERROR SQL in DB2
  254. Restoring the event monitor file
  255. plz help:i want to create db2 account Not using OS account
  256. CREATE PARTITIONED TABLE - SQL0104N error
  257. 5th Fast Track Automation batch from Quality Globe from August 9th.
  258. SELECT of Members
  259. inserted values required with the given format
  260. Compare two databases in different subsystem
  261. Lock Escalation
  262. Troubles inserting to a new unicode table....
  263. clientside backup of partioned database
  264. quiesce database problem
  265. Prevent database user to access another database
  266. Use of REORG TABLE in a C++ Applikation for db2 Version 9
  267. CLOB columns change after database restore
  268. Need to display the header as the top row in the recordset
  269. Laptop Version ?
  270. Db2admin password
  271. check constraint
  272. DB2 load utility and subsytem
  273. DB2 Concepts
  274. DB2 Vers 8.1 installation error on WinXP
  275. DB2 connectivity
  276. TCP/IP Communication Error
  277. mainframe (7.1.1) lock escalation
  278. application id
  279. how to get even or odd number rows from database in db2
  280. [Question] DB2 LUW V8, regarding after drop tablespace behavior
  281. DB2 INSERT search for space
  282. runstats from reorgchk update stat
  283. Outer Joins in MQT`s
  284. migrating SQL Server data to DB2
  285. SQL stored procedure in Z/OS (DB2 ver 7)
  286. how to *really* remove a database in DB2 ..
  287. Insert v/s Load
  288. creatin a trigger
  289. To create a trigger
  290. xml
  291. connection remote to DB2 database with the C/C++, with prohibition of installation DB2 client software.
  292. execution time in HADR
  293. ClientBean and ReportBlox
  294. V8.2 Check if nonrecoverable load was done
  295. sql update to a substring
  296. V9 Column Rename
  297. HADR performance issue
  298. Sqlstate = 56038
  299. db2 replication Center
  300. Error activating a database/cannot allocate agent
  301. DB2 Common gcf error
  302. QMF vs SPUFI
  303. import from NUL converted to ordinary delete
  304. Problems with starting DB2 service on windows
  305. SQLJ default context override
  306. DB2 queries
  307. Migrate Data from Oracle 10g Express to DB2
  308. Order of Where and Composite Key
  309. Stored Procedures for DB2 z/OS Developed with SQL Language
  310. Very basic formatting question
  311. DB2 Container Size Limit
  312. at the start of db2
  313. First process in db2 startup
  314. Errorr execute immediate
  315. displaying a date
  316. Get error SQL0723N when trying to insert a row into mainframe DB2 from web server
  317. Mqt Store Procedure
  318. Newbee Query Problem
  319. IN versus ANY versus EXISTS
  320. DB2 Load utility
  321. describe command
  322. Specifying Record Delimiter
  323. SQL0338N-Error
  324. Delete rows from two tables
  325. db2 sql query
  326. SQLCODE: -805, SQLSTATE: 51002 , this is the error code
  327. Temporary table in DB2
  328. Summing a column as a seperate column in the same query
  329. db2_pconnect SQL10007N Reason code: "3"
  330. Nested selects
  331. Invoking Stored Procedures in Triggers
  332. Oportunidade Stefanini It Solutions
  333. BEFORE OPTION
  334. Max length Locate can handle
  335. MF COBOL/DB2 Error
  336. Clob In Db2 Aix
  337. DB2 "Net Search Extender" for v9.1
  338. Define a return value in store proc.
  339. Creating Function Template in UDB 8.2 with TABLE return type for Federation
  340. SQL Error in DB2 and MS Access
  341. DB2 migration utility ?
  342. Looking for a db2 tool that converts Oracle to Db2 - Migration assistant?
  343. DB2 Express-C on Windows XP SP2 "Invalid parameter number. SQLSTATE=S1093"
  344. 64bit client application in a 32bit instance
  345. Software Testing Cycle
  346. DB2 Certification Exam question
  347. Packages and Procedures
  348. DB2 online data copy
  349. Db2-cobol Program
  350. Isolation level - interesting scenario
  351. Update difficulty
  352. Interesting isolation level problem
  353. access level problem in multiple instance
  354. db2 offline db restore from v7.2 to v8.2
  355. Version Recovery (Db2 on AIX)
  356. Formatted CURRENT DATE
  357. SQL0104N An unexpected token "DATABASE" was found following "CREATE ".
  358. After merging - how to bring over parent_ids
  359. DB2 database shutdowns after excecution of sqlj procedure
  360. VARCHAR field that is not NULL
  361. DB2 ver 7.1 Processing was cancelled due to an interrupt
  362. Help on Null
  363. LIbrary System
  364. db2 704 exams
  365. Very urgent.. need threshold levels for db2 monitoring metrics
  366. SQL Code -181
  367. 4th Fast Track Automation batch from Quality Globe from July 24th.
  368. iNFO O db2 CERTICATION REQUIRED.
  369. How to reduce the ImageCopy job run time
  370. how to ignore errors when creating stored procedure?
  371. help in DB2 Load command
  372. db2 wsad connectivity
  373. Import SPF via Script
  374. SQL0332N There is no available conversion for the source code page
  375. library system
  376. SQL0206N, case statement and time calculation
  377. Failed to load libaio
  378. Asp - Db2
  379. db2 doubt
  380. Catalog Node : Port Number
  381. HELP! declare global temporary tables?!?
  382. HOW to convert a character type into date format
  383. need a little insight on index that allows reverse scans
  384. select from a sequence and from a table in the same statement
  385. update from a select
  386. Storage quantity
  387. Commit Active problem solved (db2rhist.asc)
  388. STOP RUN in DB2 stored procedure
  389. how do you add a zero to the left of an integer
  390. view tables
  391. Retrieving latest row
  392. Error in DB2 (COBOL/DB2/CICS )
  393. Space instead of Null
  394. plan and package
  395. IBM supplied WLM stored procedures
  396. Client compatibility
  397. Oportunidade Stefanini It Solutions
  398. How does threads work in DB
  399. load vs. import ( warnings )
  400. row_number
  401. LOAD and LOAD with AMDIN_CMD
  402. Replication tutorial
  403. DB2 subsystem
  404. SQLCODE groups
  405. Db2
  406. Is there any command or tool for doing DB2 Catalogs reorg/check?
  407. complile and execute a stored procedure.
  408. Run DB2CMD commands through PowerShell
  409. DB2 versus UDB
  410. Controling tablespace for a primary key index in alter table
  411. Db2 700
  412. Need help on data replication and available options
  413. Rename a tablespace file?
  414. Is there any way to make my transcripts of the DB2 certifications viewable for public ?
  415. How to speed up this SQL statement
  416. How to extract sequences in db2 udb 8.2
  417. log table changes with a trigger...
  418. IBM and AGS Announce Availability of New Solutions for Informix Dynamic Server
  419. Contokens
  420. check pending state
  421. message in db2diag.log
  422. DB2Dart Report meaning
  423. problem during database connection test in db2 stored proc
  424. db2dascln
  425. db2 iseries
  426. Application inventory DB
  427. list of parameters that has to monitored by a DBA in db2 UDB
  428. list of Parameters that has to monitored by a DBA in db2 UDB
  429. Renaming an instance
  430. Could this be DB2 or an Access problem??
  431. How to take the database backup
  432. How to define my own exception in db2 stored procedure
  433. DB2 Trigger Help
  434. update a column on particular table relation with multiple tables
  435. ROW_NUUMBER LOOP
  436. Software Quality Management
  437. Need Help with db2 db2start throwing SQL6048N error
  438. Query help...
  439. DB Backup error
  440. DB2 Driver- ClassNotFoundException-Please help
  441. Oportunidade Stefanini It Solutions
  442. Ibm Db2 Sql
  443. Error in loading data into DB2 table
  444. common problems found in db2
  445. Universe locks
  446. command for viewing DB2 configuration parameters
  447. IBM Establishes Global Center of Excellence for Nuclear Power
  448. Corrupt Trigger Nameless
  449. Stored Procedure
  450. Error uninstalling DB2 V9.1 (XP Home)
  451. DB2 700 Exam
  452. SQLDA corrupted when using VARGRAPHIC type parameters
  453. DB2 Certification
  454. db2ReadLog, Variable format data
  455. How to do DB2 Clustering
  456. db2jstrt or db2jd on OS/390
  457. db2look -tw
  458. What are the Files generated after db2 installation
  459. Cobol precompiler query
  460. Installing and Operating DB2 Within Windows Domain
  461. Tables and Columns security in database db2
  462. Long running of DB2 Queries
  463. Creating Indexes For Declared Temporary Tables
  464. How to execute a procedure in DB2
  465. CMMI Practices
  466. DB2 trigger failing while calling stored procedure
  467. How to change the primary key for already existing table?
  468. Statistics with volatile table
  469. Cannot Load
  470. Third Fast Track Automation batch from Quality Globe from July 5th.
  471. "Best Fit" Match against multiple tables?
  472. PHP5, ibm_db2 connection problem
  473. COBOL DB2 V8 Mainframe - moving data from one table to another
  474. Primary Key
  475. DB2 Model
  476. Primary Key
  477. specified attributes not existing with existing column error on Altering table
  478. Getting error whle changing the Datatype of a column in the table.
  479. When to use cursors?
  480. Migration from V8(solaris) to V9(redhat)
  481. normalizing two related tables
  482. How to specify the creator in db2connect
  483. Left outer join with case
  484. Dates, DB/2 and Java
  485. Query's Strange Behavior
  486. [IBM][CLI Driver][DB2/6000] SQL0952N - HELP
  487. DB2V8.2 DPF CPU Usage
  488. AS400JDBCDriver, encoding charset
  489. Issues when deploying applications on WebSpeher process server.
  490. [IBM][CLI Driver] SQL1284N The attempt to connect to database
  491. Query from more than 2 database
  492. Query from more than 2 database
  493. Please..need SHA1 implemented in DB2 version 8
  494. Need help on deleting log file (log_dir)
  495. UDF's crash after new CPU installation on AIX!
  496. set integrity
  497. The database manager is not able to accept new requests, has terminated all requests
  498. how to declare temp tables in a user-defined function
  499. Non-SOAP Web Service in DB2 9
  500. Event monitor that gives more lock info?
  501. Error Message Retreival in SQL Stored Procedures
  502. Applying CURRENT TIMESTAMP On Updates
  503. Db2
  504. What is the difference between BIND REPLACE and REBIND commands?
  505. Basic doubt in union.
  506. JDBC: Connected but no tables shown
  507. DB2 SQL Query
  508. timestamp
  509. Db2javit:rc=9505
  510. Delete table command in DB2 SQL ?
  511. db2 9 processes on linux.
  512. how to add a logical partition on the same computer.
  513. Replication : when asn.IBMSNAP_UOW is pruned ?
  514. BACKUP PENDING(Help me,Please)
  515. Inoperative packages vs. invalid packages
  516. Self Join in DB2 SQL
  517. Troubles using DB2, Websphere 3.5 and Java
  518. Effect of manually updating AVGCOMPRESSEDROWSIZE?
  519. is this table function possible for IBM DB2 v8.2?
  520. Mapping between Package and DBRM.
  521. JDBC type 4 driver for DB2 v7.1
  522. case and count
  523. SIMPLE but SLOW SELECT query!!!
  524. where do i declare the user temporary tablespace?
  525. temporary global tables
  526. Replication error
  527. functions that returns a table
  528. I cannot find License key
  529. Data Dictionary counterpart in DB2
  530. lock escalation : how "expensive"?
  531. INSERT Trouble
  532. How to create user Temporary table in DB2
  533. Migrate from v7 to v9, 32 to 64 bit
  534. How to Update Blob with JDBC?
  535. Generated Always As Identity
  536. COMPRLIB in backup
  537. Comparison of two rows in a table using SQL ?
  538. Setting a default schema for a particular group
  539. Removing a record from resultset using SQL
  540. Define tablespaces with different size paging into DB2
  541. Handling Null from a stored procedure
  542. truncate table for DB2 - differences
  543. Hosting Robots On Terminal Server
  544. Can Not Create Database - DAS Is Not Active
  545. what is a fully qualified table name in DB2 ?
  546. Script for db2 backup
  547. DB2 Trigger syntax
  548. DB2 Trigger syntax
  549. HTTP Web Service Consumer
  550. db2 inplace reorg and log space