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